Forum Discussion
IF functions returning *awaiting data* if the cell is blank
Hi, I am trying to create an IF function to make a cell as awaiting data, if another cell on the same sheet is empty... I already have 3 if functions set up **=IF(F3>G3,"under capacity",IF(F3<G3,"ove...
For example:
=IF(G3="", "awaiting data", IF(F3>G3, "under capacity", IF(F3<G3, "over capacity", IF(F3=G3,"at capacity"))))
or
=IFS(G3="", "awaiting data", F3>G3, "under capacity", F3<G3, "over capacity", F3=G3,"at capacity")
- wow.. thank you Hans.... that was super fast reply and has worked a treat !! Where was I going wrong as I had tried if(g3)="", awaiting data at the end of my line.. but it just didn't want to work ? was it something I had done wrong ? again.. thank you for your speedy answer.. that's amazing 🙂
In if(g3)="" there shouldn't be a closing parenthesis ) after g3, for that makes Excel think the formula ends there. It should be at the very end of the formula instead.
- ahhhh ok. thank you 🙂
