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!”
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