Mr

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.

Help much appreciated.

Regards

David

By: David

4,173 thoughts on “Mr

  1. nalodowke

    If some one wishes to be updated with most recent technologies afterward he must be pay a quick visit
    this web page and be up to date all the time.

  2. iamgutsclub.com

    An impressive share! I have just forwarded this onto a friend who had been conducting a little homework on this. And he in fact ordered me breakfast because I discovered it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanx for spending the time to discuss this issue here on your web site.

  3. kqxsmt thu 2

    Wonderful post however , I was wondering if you
    could write a litte more on this subject? I’d be very thankful if you could elaborate a
    little bit further. Appreciate it!

  4. eyfas.com

    Hello there, I think your site could possibly be having web browser compatibility problems. Whenever I look at your website in Safari, it looks fine however, when opening in Internet Explorer, it has some overlapping issues. I simply wanted to provide you with a quick heads up! Aside from that, fantastic website!

  5. App Para Tv Box Mx9

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  6. tokoonline88

    Hello, There’s no doubt that your blog could possibly be having browser compatibility problems. When I take a look at your blog in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I just wanted to provide you with a quick heads up! Apart from that, excellent website!

  7. vivo slot

    I blog often and I seriously thank you for your information. This great article has really peaked my interest. I’m going to bookmark your blog and keep checking for new details about once a week. I subscribed to your Feed as well.

  8. vivoslot

    Greetings! Very useful advice within this article! It is the little changes that make the greatest changes. Thanks for sharing!

  9. 谷歌优化

    Do you have a spam problem on this website; I also am
    a blogger, and I was wanting to know your situation; many of us have created some nice methods and we
    are looking to exchange strategies with other folks, please shoot me an e-mail if interested.

  10. рецепты печь пасхи

    Nice post. I was checking continuously this blog and I am inspired! Very useful information specially the final phase 🙂 I care for such info a lot. I was looking for this particular info for a very lengthy time. Thank you and good luck. | а

  11. link alternatif vivoslot

    You are so cool! I do not suppose I have read a single thing like that before. So great to find another person with some original thoughts on this subject. Really.. thank you for starting this up. This web site is something that is needed on the web, someone with some originality!

Comments are closed.