Excel nested Round with OR functions

811 Views 3 Replies 2 Participants Last post by CodeLexicon, Dec 16, 2015

CarolYoung

Discussion Starter · Dec 16, 2015

I have a working formula, it tests if cell F4 is equal to a range of other cells.
I need it to test both E4 OR F4 and I just can't figure out how to get it to work and I'd really appreciate some advice? The formula that works for just F4 is:
=IF(ROUND(F4,2)=ROUND((G4-H4-I4+J4-SUM(K4:AG4)),2),"OK","Oops")

Save

Status: Not open for further replies.

1 - 4 of 4 Posts

CodeLexicon

· #2 · Dec 16, 2015 (Edited)

Here you go, should work (posting from phone) ...

=IF(OR(ROUND(E4,2)=ROUND((G4-H4-I4+J4-SUM(K4:AG4)),2),ROUND(F4,2)=ROUND((G4-H4-I4+J4-SUM(K4:AG4)),2)),"OK","Oops")

Save

Reactions: 1

CarolYoung

Discussion Starter · #3 · Dec 16, 2015

CodeLexicon you rock! Thank you so much! It makes complete sense now that I see it. Thank you!

Save

CodeLexicon

· #4 · Dec 16, 2015

You're welcome.

Save

1 - 4 of 4 Posts

Status: Not open for further replies.

Top Contributors this Month