Excel IF Command

0

i have 3 column JAn, Feb, Mar.

if values are present in all A1,B1,C1 column then display "30-90".

if values are present only in A1,B1 not in C1 column then display as "30-60".

If values are present only in A1 and not in B1,C1 then display as "#N/A".

Please let me kw the solution soon as possible, Screenshot is as below.

Answer
Discuss

Answers

0
=IF(AND(NOT(ISBLANK(C1)),NOT(ISBLANK(B1)),NOT(ISBLANK(A1))),"30-90",IF(AND(ISBLANK(C1),NOT(ISBLANK(B1)),NOT(ISBLANK(A1))),"30-60",IF(AND(ISBLANK(C1),ISBLANK(B1),NOT(ISBLANK(A1))),"#N/A","")))

Here are some of our tutorials that will also help you learn how to do this and edit this formula:

How to Use the IF Function in Excel

Check if Cell is Empty or Not in Excel

AND Function - Check if All Arguments are True

Discuss

Discussion

Hello Thanks for your reply. But when i copied same and checked
I got "30-90"  as all fianl values.
seems synatx is ryt, but i dont kw whats the prob
Teku Apr 6, '17 at 1:33 pm
You must have copied it wrong or something else is going on. Upload a sample file with an example of how you want it to look because it seems like you must have described it incorrectly. The formula that I made does exactly what you asked for in your question.
don (rep: 1492) Apr 6, '17 at 1:47 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login