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

3,394 thoughts on “Mr

  1. Lexus888 Versi mobile

    Hey there! This is my first comment here so I just wanted to give a quick shout
    out and tell you I really enjoy reading your articles.

    Can you recommend any other blogs/websites/forums that deal with the same subjects?
    Thank you!

  2. hemlockspruce.design.blog

    Hi there very cool web site!! Man .. Beautiful ..

    Amazing .. I’ll bookmark your site and take the feeds additionally?
    I’m happy to search out so many helpful info right here within the publish,
    we’d like work out more techniques on this regard, thank you for sharing.
    . . . . .

  3. aplikasi joker123

    After looking into a number of the blog articles on your website, I seriously like your technique of writing a blog. I saved as a favorite it to my bookmark webpage list and will be checking back soon. Take a look at my website too and let me know what you think.

  4. worldstar mobile entertainment

    Right here is the perfect blog for anybody who would like to understand this topic. You realize so much its almost tough to argue with you (not that I personally will need to…HaHa). You definitely put a fresh spin on a topic that has been written about for decades. Wonderful stuff, just excellent!

  5. thewatchseries movies

    I’m impressed, I must say. Seldom do I encounter a blog that’s both equally educative and engaging, and let me tell you, you have hit the nail on the head. The issue is something that not enough folks are speaking intelligently about. I’m very happy I found this in my search for something relating to this.

  6. joker388 login

    The very next time I read a blog, I hope that it won’t disappoint me just as much as this one. I mean, Yes, it was my choice to read, but I actually thought you would have something helpful to talk about. All I hear is a bunch of moaning about something that you could possibly fix if you weren’t too busy looking for attention.

  7. domino 99

    Hello there! I could have sworn I’ve been to this website before but after looking at many of the articles I realized it’s new to me. Nonetheless, I’m certainly delighted I discovered it and I’ll be book-marking it and checking back frequently!

  8. login joker123 slot

    Hi, I believe your website could be having web browser compatibility issues. Whenever I look at your blog in Safari, it looks fine however, if opening in IE, it’s got some overlapping issues. I simply wanted to give you a quick heads up! Besides that, wonderful blog!

  9. joker188 login

    An intriguing discussion is definitely worth comment. I do believe that you ought to publish more about this subject, it might not be a taboo matter but usually people don’t discuss these subjects. To the next! Best wishes!!

  10. yify proxy

    Your style is really unique compared to other folks I have read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I will just book mark this blog.

  11. DominoKiu

    Hi there, I do believe your blog could possibly be having web browser compatibility issues. When I take a look at your site in Safari, it looks fine but when opening in Internet Explorer, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Apart from that, excellent blog!

  12. deposit joker388

    You are so cool! I don’t suppose I’ve truly read through something like that before. So wonderful to find another person with a few unique thoughts on this subject matter. Seriously.. thank you for starting this up. This web site is one thing that is needed on the web, someone with a bit of originality!

  13. holland casino venlo eten

    gokkasten gratis fruitmachines gfm , ovo casino bonuscode 2020 – holland casino eindhoven route : bv beginnen zonder inleg .

  14. 카지노 사이트

    Thanks for every other excellent article. The place else could anyone get that type of info in such a perfect
    method of writing? I have a presentation subsequent week, and I am
    at the look for such information.

  15. w88

    Hello to all, how is everything, I think every
    one is getting more from this site, and your views are good designed for new users.

  16. toko obat kuat bandung

    An impressive share! I’ve just forwarded this onto a co-worker who had been conducting a little research on this. And he in fact bought me lunch because I stumbled upon it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanks for spending some time to discuss this subject here on your site.

  17. poker88

    I want to to thank you for this good read!! I absolutely loved every bit of it.
    I’ve got you book marked to look at new stuff you post…

  18. obat kuat di bandung

    Hi there! I could have sworn I’ve been to this site before but after looking at a few of the posts I realized it’s new to me. Anyhow, I’m definitely delighted I found it and I’ll be book-marking it and checking back regularly!

Leave a Reply

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