Mr

Help with excel formula nested IF statement in simpe spreadsheet using Excel 2016 with Windows 10.

 

Hi, I am trying to include a nested formula in a spread sheet. the formula is =IF($G22=”S”,$E22-205,””,IF($G22=2,E22))

G22 is either S or 2. If S I want the current cell to subtract 205 from the value of E22 and if 2 I want to simply use the value at E22. When I use the formula above I get and error stating that I have entered too may arguments for this function.

Helpmuch appreciated.

Regards

David

By: David

22 thoughts on “Mr

  1. Kimberley Price

    Hi David,

    Try this formula instead;

    =IFS(G22=”S”,E22-205,G22=2,E22)

    (You may need to correct the bits past IFS)
    IFS is a great tool for more than one argument like your situation as you want to say If it’s doing this, do this, or if it’s doing this, do that.

    Hope this helps!

    -Kim

  2. farmacija

    It as not that I want to copy your website, but I really like the style and design. Could you let me know which style are you using? Or was it especially designed?

  3. nike air max 95

    I was very happy to search out this web-site.I wanted to thanks in your time for this excellent read!! I positively enjoying every little bit of it and I have you bookmarked to take a look at new stuff you weblog post.

Leave a Reply

Your email address will not be published. Required fields are marked *