Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.

excel
MS Office Version: 146
posted by: Teku on Thu Apr 6, 2017 at 12:45 pm
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

posted by: don (rep: 1989) on Thu Apr 6, 2017 at 1:23 pm
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: 1989) 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