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

12 thoughts on “Mr

  1. goyard

    Whats up! I just wish to give an enormous thumbs up for the nice information you might have here on this post. I will be coming again to your blog for more soon.

Leave a Reply

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