Forum Discussion
Nicole .
Nov 30, 2017Copper Contributor
If formula giving a False answer
Hi All,
I have written the following formula:
=IF(G8="F",IF(J8=" ",Q8),P8)
G8 has an F in it, Q8 has another formula in it that produces a number and when J8 is blank I get the numb...
SergeiBaklan
Nov 30, 2017MVP
Perhaps
=IF(G8="F",IF(ISBLANK(J8),Q8,P8))