Hi

=0.2+(C22-1)*(B13-0.4)/5


Arvi Laanemets


"Wazza" wrote in message
...

Here's is the formula that I am trying to use, I want to get an answer
using a variable (B13) based on whether the cell is 1,2,3,4,5,6 I'm
fairly new to this so any help would be awesome.


=IF(C22=1,"=0.2",IF(C22=2,"=((B13-0.4)/5)+0.2",IF(C22=3,"=(((B13-0.4)/5)*2)+
0.2",IF(C22=4,"=(((B13-0.4)/5)*3)+0.2",IF(C22=5,"=(((B13-0.4)/5)*4)+0.2",IF(
C22=6,"=B13-0.2"))))))


--
Wazza
------------------------------------------------------------------------
Wazza's Profile:
http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=276384