if statement returning blanks

[Mayrie]

I have a cell with the following conditions:

if b2="a" then b3
if b2 does not equal "a" then look at b3
if b4="a" then b5, otherwise leave cell blank.

I tried to use a nested if function like this:

if(b2="a", b3, if(b4="a", b5, " ")) but it doesn't seem to be working. my cell values are formatted as times (1:30 PM) and some of the times are past midnight. I don't know if that makes a difference. The formula is working in some cells, but just blank in others, but I am not getting any error messages.

Any help would be greatly appreciated.

[NBVC]

Formula looks like it should work.. can you post sample worksheet?

[modytrane]

Please Login or Register  to view this content.

Your formula doesn't match the description.
If b2 does not equal "a" then formula looks at b4, instead of b3 [per your description].

May be it's just a typo, but I just want to make sure you know about it.
modytrane.

[ChemistB]

Another small note. At the end of your formula,
" " puts a space into the cell, not a blank. "" is more commonly used.