1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved Excel nested Round with OR functions

Discussion in 'Business Applications' started by CarolYoung, Dec 15, 2015.

Thread Status:
Not open for further replies.
Advertisement
  1. CarolYoung

    CarolYoung Thread Starter

    Joined:
    Dec 15, 2015
    Messages:
    3
    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")
     
  2. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
    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")
     
    Last edited: Dec 16, 2015
    CarolYoung likes this.
  3. CarolYoung

    CarolYoung Thread Starter

    Joined:
    Dec 15, 2015
    Messages:
    3
    CodeLexicon you rock! Thank you so much! It makes complete sense now that I see it. Thank you! :D
     
  4. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
    You're welcome. :D
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1162345

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice