Get instant live expert help on I need help with excel if null

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

How can I make an IF function that flags null as FALSE? (With null I mean no value)
Solved by C. J. in 17 mins
I am trying to add a name to column C when column B is null =IF(B2 is null,E2,B2) I am getting the #NAME?
Solved by O. S. in 23 mins
My excell formula is not working for me. I am trying to get if >=5 Whole or < 4 but > 2 Half and <2 null: IF((OR(C73 >= 5, "Whole"), (C73 < 4 "Half"), (C73 < 2 "Null")))
Solved by M. F. in 22 mins
If cell is null how to take automatically another cell which contains values
Solved by Z. W. in 29 mins
=IF(ERROR(N25/(GETPIVOTDATA("StatusPriceAdjustedUSD_amt",'Pivot Country_IncomeProp'!$G$14,"Country_tx",M25)/1000000)-1),N25/(GETPIVOTDATA("StatusPriceAdjustedUSD_amt",'Pivot Country_IncomeProp'!$G$14,"Country_tx",M25)/1000000)-1,NULL) This function is not recognising the "NULL" at the end what am i doing wrong
Solved by G. Q. in 23 mins