| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
lol
that is a "little bit" simpler than my formula -- Regards Frank Kabel Frankfurt, Germany "Arvi Laanemets" schrieb im Newsbeitrag ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| how do i create a blank cell in excel using a formula | Excel Worksheet Functions | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Threaded Mode
