Forum Discussion

carian barber's avatar
carian barber
Copper Contributor
Oct 25, 2017

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 fields".

and:

If cell A1 is empty and B2 is empty I want C3 to also be empty.

Would this be possible?

 

Thanks in advance!

 

Formulas & Functions
Need Help
  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    Steel Contributor
    Oct 25, 2017
    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",""))

Resources