Use the numerical result of one formula in another

[misterfish]

Help!


I would really appreciate some help in understanding how to use the result of one formula in another.


I have a simple spreadsheet, which will be updated regularly (actually golf handicap calculations) so that several fields will change as a result of updating weekly scores.

First formula uses the IF function to determine a group, expressed as a number between one and five. The second formula should use a sliding scale based on the result of the first


The first formula is in cell I2 :-

=IF(F2>28.4,"5",IF(F2>20.4,"4",IF(F2>12.4,"3",IF(F2>5.4,"2","1"))))


The second formula tries to use the result of cell I2 :-

=IF(I2=5,"0.5",IF(I2=4,"0.4",IF(I2=3,"0.3",IF(I2=2,"0.2",IF(I2=1,"0.1","")))))


- but no matter what number is returned in the first formula, it always returns blank as I assume it reads the formula and not the result of that formula.


The next stage will be to use a third formula based on the numerical result of the second....... I know I could use a copy/paste values operation but the spreadsheet is to be used by a non-technical bod.


Or maybe I am trying to achieve the impossible?


All contributions gratefully received


Misterfish

 

[Hui]

Take of all the quotes around the numbers in the first formula in I2

They should be 5 not "5"

Same in second formula

 

[NARAYANK991]

Hi ,


To add to what Hui has pointed out , can the second formula not be simplified ?


After all , I2 is guaranteed to have only integer values from 1 to 5 ; so the second formula can be simplified to =I2*0.1 or =I2/10.


Narayan