Forum Discussion
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...
Nicole,
probably this:
=IF(G8="F",IF(J8="",Q8,P8))
Detlef, again one minute gap...
Yeah, I just noticed.
Curious thing: I almost used "perhaps" but then decided for "probably". :-)