Hi
try:
=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
))))))

--
Regards
Frank Kabel
Frankfurt, Germany

"Wazza" schrieb im Newsbeitrag
...

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