Help with IF statement returning a blank value

  • Thread starter Thread starter rg8407
  • Start date Start date
R

rg8407

I am trying to set up a nested IF statement where one option is to hav
a blank value returned. The statement works correctly, however, wher
a blank should return, a 0 is there. Here is what I am trying to do:

=IF(E123=E122,S122,IF(E123<>E122,H123,IF(E123="","")))

IF E123=E122 return value of S122
IF E122 does not equal E122 return value of H123
IF E123 is blank, return a blank value


I have attempted this several different ways, this was the last thing
did.


Thank
 
=IF(E123=E122,S122,IF(E123<>E122,H123,IF(E123="","","")))

you can add in an extra "" like above.. of course if S122 or H123 is blank
you'll get a 0.
 
Hi
you forgot the last False option. try
=IF(E123=E122,S122,IF(E123<>E122,H123,IF(E123="","","")))
 
Thanks both Dave and Frank, but I am still having a problem. Dave, yo
seem to touch on it in your reply. I have a series of inventor
information in the columns. E123 is the inventory number. If that i
blank, I want the cell with the IF statement to be blank. The proble
is if that is blank, chances are good S122 and H123 are also going t
be blank. Can you help with this.

Thanks again,
Ron
 
Back
Top