+ Reply to Thread
Results 1 to 4 of 4

Can i add an IF inside of an IF? (nested?)

  1. 05-27-2011, 03:51 PM #1
    Bajungadustin
    Guest

    Can i add an IF inside of an IF? (nested?)

    the code now is

    Please Login or Register  to view this content.
    the problem is all the math that is involved is adding numbers when it needs to not be counted. for example in this code G13 is my user input and it is 0 however it returns a result of 6 and i need it to be 0 if no data is entered into G13... soo...

    Please Login or Register  to view this content.
    is there something similar to this?
    Last edited by Bajungadustin; 05-27-2011 at 04:10 PM.
    Reply With QuoteRegister To Reply
  2. 05-27-2011, 04:06 PM #2
    Bajungadustin
    Guest

    Re: Can i add an IF inside of an IF? (nested?)

    got it myself :P

    =IF(G13>0,IF(G17>40, (G18*V22)+(G13*O22),G13*O22),0)
    Reply With QuoteRegister To Reply
  3. 05-27-2011, 04:18 PM #3
    Bajungadustin
    Guest

    Re: Can i add an IF inside of an IF? (nested?)

    Quote Originally Posted by Bajungadustin View Post
    got it myself :P

    =IF(G13>0,IF(G17>40, (G18*V22)+(G13*O22),G13*O22),0)
    nope im wrong. if i do this it alters the output for those areas WITH user entered data.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-27-2011, 04:22 PM #4
    Bajungadustin
    Guest

    Re: Can i add an IF inside of an IF? (nested?)

    dang.. nevermind.. i forgot to move the boxes after i filled it down.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1