IF statement when formula result is blank

B

Bonnie

I am trying to use the conditional formula:
=IF(F7="",D7,F7) where F7 is a vlookup formula that returns a general value

If the result of the vlookup is a blank cell, how do I reference that
vlookup result in order for the IF statement to return D7?

Thanks!
 
B

Bob Phillips

That should work as is.

Try

=IF(TRIM(F7)="",D7,F7)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
I

ilanr01

Bonnie said:
I am trying to use the conditional formula:
=IF(F7="",D7,F7) where F7 is a vlookup formula that returns a genera
value

If the result of the vlookup is a blank cell, how do I reference that
vlookup result in order for the IF statement to return D7?

Thanks!
Click to expand...

Try =IF(isblank(F7)="",D7,F7)
Ila
 
Top