Forum Discussion
chealy79
Feb 07, 2023Copper Contributor
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...
HansVogelaar
Feb 07, 2023MVP
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.
chealy79
Feb 07, 2023Copper Contributor
ahhhh ok. thank you 🙂