Nested Ifs issue

[andrewb90]

Hello all,

I am trying to change a nested if formula by adding additional information, and I seem to be doing it incorrectly. I was hoping somebody could assist me, and point out where I am going wrong.

=IF(Scheduler!F89<>"",IF(Scheduler!F89=Settings!G5,"Close",IF(RO!D4="1","OFF","Scheduler!F89")))

What I am trying to do is:
If Scheduler!F89 is blank, then the cell is blank
If Scheduler!F89 has the same value as Settings!G5 then the text "Close" appears
If RO!D4 has a value of 1, the "OFF" will appear
Otherwise the value of Scheduler!F89 will appear

Scheduler & Settings are both time value (6:00, 11:00, etc)


Any help would be greatly appreciated!

 

[Dryver14]

what are the priorities here for instance if RO!D4 = 1 does F89 stay blank?

 

[andrewb90]

The cell would only stay blank if none of the other conditions are met, so if F89 has no value entered into it and RO!D4 does not have a value of 1.
Also, F89 will not have a value while RO!D4 has the value of 1. It's an either or.

 

[Dryver14]

try this

=IF(Scheduler!F89="","",IF(Scheduler!F89=Settings!G5,"Close",IF(RO!D4="1","OFF","Scheduler!F89")))

 

[andrewb90]

So the "off" isn't appearing as it supposed to, If Scheduler!F89 is blank the cell should stay blank unless RO!D4 = 1.

 

[andrewb90]

I think I got it figured out now.

=IF(Scheduler!F89="",IF(RO!D4="1","OFF",""),IF(Scheduler!F89=Settings!G5,"CLOSE",Scheduler!F89))

I appreciate the help everybody!

 

[Dryver14]

I can not see anything wrong with your original formula then apart from there is no need to put "" around 1

=IF(Scheduler!F89<>"",IF(Scheduler!F89=Settings!G5,"Close",IF(RO!D4=1,"OFF","Scheduler!F89")))