Forum Discussion
carian barber
Oct 25, 2017Copper Contributor
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...
SergeiBaklan
Oct 25, 2017Diamond Contributor
Hi Carian,
Something like
=IF(LEN(B2)=0,IF(LEN(A1)=0,"","text"),"")