IF statement when formula result is blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
That should work as is.

Try

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
Back
Top