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 number in Q8, however if J8 is not blank (has a date) instead of the number in P8 I get FALSE.
How do I get the number that is in P8? I have already tried adding +0 to my formula in Q8 & P* in case Excel was treating it as text.
Thanks x
Perhaps
=IF(G8="F",IF(ISBLANK(J8),Q8,P8))
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". :-)
