ebookslogoboss

1. If Blank Do Nothing Excel Free
2. If Blank Do Nothing Excel File

Apr 16, 2018 - In Microsoft Excel, when you use a formula that tests for a zero value, you may see unexpected results if the cell is blank. Microsoft Excel. ISBLANK:This function can be used tocheck for blank or null values in a range. IF:- IF condition allows us to use multiple conditions in a cell. It helps us to make the function flexible and Excel allows us to use a maximum of 64 conditions in a cell. Example:Cells A2 and A3 contain the numbers 3 and 5.

I have this simple statement in excel. I compare two dates. If the date 2 is greater than or equal to date 1, then I show 1. If not, then I show 0.

However, I would like to apply this function only when the cells contains text:

If Blank Do Nothing Excel Free

That gives me an error - what am I doing wrong?

Arunaoliverbjoliverbj

2 Answers

Your formula is wrong. You probably meant something like:

Another equivalent:

Or even shorter:

OR EVEN SHORTER:

TaosiqueTaosique

If Blank Do Nothing Excel File

You need to use AND statement in your formula

=IF(AND(IF(NOT(ISBLANK(Q2));TRUE;FALSE);Q2<=R2);'1';'0')

And if both conditions are met, return 1.

You could also add more conditions in your AND statement.

Not the answer you're looking for? Browse other questions tagged excel or ask your own question.