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.