Help with IF statement returning a blank value

[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

 

[Dave R.]

=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.

 

[Frank Kabel]

Hi
you forgot the last False option. try
=IF(E123=E122,S122,IF(E123<>E122,H123,IF(E123="","","")))

 

[rg8407]

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

 

[Frank Kabel]

Hi
in this case re-order your criteria. Try
=IF(E123="","",IF(E123=E122,S122,H123))

 

[rg8407]

Frank,

Thank you very much. This worked perfectly.

Ron