Forum Discussion
Please Help!
Hi, I am trying to create a formula for a stock inventory spreadsheet. Here is an example of what I would like: If cell A1 is not empty and B2 is empty I want C3 to state "Please complete all f...
Hi Carian,
First I assume you mean B1,
(In case you want B2 you can change the B1 in my formula to B2)
=IF(LEN(A1)=0," ",IF(LEN(B1)=0,"Please complete all fields",""))
In case you want the formula to return " please complete all fields if either A or B is empty
=IF(LEN(A1)=0,"Please complete all fields",IF(LEN(B1)=0,"Please complete all fields",""))
First I assume you mean B1,
(In case you want B2 you can change the B1 in my formula to B2)
=IF(LEN(A1)=0," ",IF(LEN(B1)=0,"Please complete all fields",""))
In case you want the formula to return " please complete all fields if either A or B is empty
=IF(LEN(A1)=0,"Please complete all fields",IF(LEN(B1)=0,"Please complete all fields",""))
Jihad, what's the difference?
