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.



By: David

3,893 thoughts on “Mr

  1. genolyze

    After I initially left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I receive 4 emails with the same comment. Perhaps there is a means you are able to remove me from that service? Kudos!

  2. jasa backlink pbn

    Jasa Backlink dgn backlink PBN dan SEO bisa meringankan menaikan seri situs anda bersama cepat
    seandainya kamu pusing merangking website kalau anda binggung menmbahkan merek business kamu atau bila kamu galau dan sudah
    selesai keluar anggaran yang tidak sedikit untuk optimasi website kamu maka ketika ini, kamu beruang di web yang tepat kami berharap supaya kita berjodoh
    dan mendapati rejeki pada berjuang dengan lantaran rejeki itu bersumber
    bermula satu buah interaksi yg baik tanpa memotivasi merugikan satu dengan yg lainnya.

    Sponduu Indonesia premium digital marketing partner
    Jasa backlink SEO bermutu bersama PBN (Private
    Blog Network) kepada optimasi situs dgn aman, permanen dan manual layanan jasa iklan google adwords yang di melakukan oleh Sponduu Indonesia terhadap menaikan jalan atau optimalkan branding industri anda di
    search engine, bersama pengalaman yang sudah matang dan tidak sedikit jalankan bersekolah pertanyaan dalam mencari susunan yg baik dan sahih buat setiap pengguna
    telah mendirikan hamba yang merupakan pengganti yang cocok pada kamu Tentu sudah beberapa
    ratus pelanggan yang dipersetujui aku optimasi dan puluhan klien baru setiap bulan nya, mereka pilih aku untuk mempermudah dan menaikan runtunan situs mereka
    di search engine tanpa repot.

  3. 576p auflösung

    Hey There. I found your weblog the usage of msn. This is a very
    well written article. I’ll be sure to bookmark
    it and come back to read more of your useful info.
    Thanks for the post. I’ll definitely comeback.


    Your style is really unique in comparison to other people I have read stuff from. I appreciate you for posting when you’ve got the opportunity, Guess I’ll just book mark this site.

  5. poboleda

    You need to take part in a contest for one of the most useful blogs on the web. I’m going to highly recommend this website!


    I blog often and I seriously appreciate your information. Your article has truly peaked my interest. I will take a note of your blog and keep checking for new information about once per week. I subscribed to your RSS feed too.

  7. тушёнка гост 5284 84

    you’re truly a excellent webmaster. The website loading velocity is amazing. It sort of feels that you’re doing any distinctive trick. In addition, The contents are masterwork. you’ve performed a excellent task in this subject!| а

  8. Jodi

    Just wish to say your article is as astounding. The clarity in your
    post is simply spectacular and i can assume you’re an expert on this subject.
    Fine with your permission let me to grab your RSS feed to keep
    updated with forthcoming post. Thanks a million and please carry
    on the gratifying work.

  9. judi online

    Hello, i think that i saw you visited my site so i came to “return the favor”.I’m attempting to find things to improve my website!I suppose its
    ok to use some of your ideas!!


    Hi there! This post could not be written any better! Reading through this post reminds me of my previous roommate! He always kept preaching about this. I am going to forward this article to him. Fairly certain he’ll have a very good read. I appreciate you for sharing!

  11. buy wedding silk sarees

    Нoѡdy! Someone in my Myspace group sharеd this website with
    us so I came to lοok it oveг. I’m definitely enjoying
    tһe information. I’m bookmarking and will Ƅe tweeting this to
    my folⅼowers! Great blog and terrific style and desiɡn.

  12. vivoslot

    I blog frequently and I truly appreciate your information. Your article has truly peaked my interest. I’m going to book mark your blog and keep checking for new information about once per week. I subscribed to your RSS feed as well.


    wonderful issues altogether, you simply received a new reader. What might you recommend in regards to your publish that you simply made some days ago? Any sure?

  14. vivoslot login

    After I originally commented I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on each time a comment is added I recieve 4 emails with the exact same comment. Is there a way you are able to remove me from that service? Thanks a lot!

  15. vivoslot ios

    Your style is very unique in comparison to other folks I’ve read stuff from. Thank you for posting when you have the opportunity, Guess I will just book mark this web site.

  16. vivo slot online

    Hi there! I could have sworn I’ve visited this web site before but after looking at a few of the posts I realized it’s new to me. Anyways, I’m definitely pleased I came across it and I’ll be bookmarking it and checking back frequently!

  17. dingdong togel

    Howdy, I think your site could be having internet browser compatibility problems. When I look at your site in Safari, it looks fine but when opening in I.E., it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Other than that, wonderful site!

  18. dingdong togel 24d

    Aw, this was an incredibly nice post. Taking a few minutes and actual effort to produce a top notch article… but what can I say… I hesitate a whole lot and never seem to get nearly anything done.

  19. dingdong online

    I absolutely love your website.. Pleasant colors & theme. Did you create this website yourself? Please reply back as I’m looking to create my own personal site and want to find out where you got this from or just what the theme is named. Appreciate it!

  20. qq online

    Hi there! This blog post couldn’t be written any better! Going through this article reminds me of my previous roommate! He continually kept talking about this. I will send this article to him. Pretty sure he’ll have a very good read. Thank you for sharing!

  21. 3 класс русский язык канакина упражнение 212 ответ

    hey there and thank you for your info – I’ve definitely picked up anything new from right here. I did however expertise some technical issues using this web site, since I experienced to reload the website lots of times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will often affect your placement in google and can damage your quality score if ads and marketing with Adwords. Anyway I’m adding this RSS to my email and can look out for a lot more of your respective intriguing content. Make sure you update this again very soon.| а

  22. agen judi online resmi

    After looking at a few of the blog posts on your web site, I truly like your technique of writing a blog. I added it to my bookmark website list and will be checking back in the near future. Take a look at my web site too and let me know how you feel.

  23. agen judi online terpercaya

    A motivating discussion is worth comment. I do believe that you should write more about this issue, it may not be a taboo subject but generally people do not discuss these topics. To the next! Kind regards!!

  24. qq

    Nice post. I learn something totally new and challenging on websites I stumbleupon everyday. It will always be helpful to read content from other writers and use a little something from other websites.

  25. Hertha Seekins

    I carry on listening to the newscast lecture about receiving free online grant applications so I have been looking around for the top site to get one. Could you tell me please, where could i acquire some?

Comments are closed.