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

1,816 thoughts on “Mr

  1. dominoqq

    Howdy! I could have sworn I’ve visited your blog before but after going through a few of the posts I realized it’s new to me. Regardless, I’m definitely happy I found it and I’ll be book-marking it and checking back frequently!

  2. daftar kristalpoker

    Having read this I thought it was very enlightening. I appreciate you taking the time and energy to put this information together. I once again find myself personally spending a lot of time both reading and posting comments. But so what, it was still worth it!

  3. free movie streaming

    This is the right website for anyone who would like to understand this topic. You understand a whole lot its almost hard to argue with you (not that I really will need to…HaHa). You certainly put a fresh spin on a topic that has been discussed for decades. Wonderful stuff, just excellent!

  4. situs judi online terbaik

    I’m impressed, I have to admit. Seldom do I encounter a blog that’s equally educative and entertaining, and without a doubt, you have hit the nail on the head. The problem is something that too few men and women are speaking intelligently about. Now i’m very happy I came across this during my hunt for something relating to this.

  5. poker88

    May I just say what a relief to find somebody that really understands what they’re discussing over the internet. You certainly realize how to bring an issue to light and make it important. A lot more people should look at this and understand this side of the story. It’s surprising you aren’t more popular since you certainly have the gift.

  6. situs judi online terpercaya

    Can I just say what a comfort to uncover someone who really understands what they are talking about online. You definitely realize how to bring a problem to light and make it important. A lot more people must check this out and understand this side of the story. I was surprised you’re not more popular because you definitely have the gift.

  7. dominoqq

    Right here is the right website for everyone who really wants to understand this topic. You know so much its almost hard to argue with you (not that I personally would want to…HaHa). You definitely put a new spin on a topic that has been written about for many years. Wonderful stuff, just great!

  8. amazon discount

    Fantastic beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog site? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear idea

Leave a Reply

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