=if(condition1,responce1,If(condition2,responce2,r esponce3)
or
=if(and(condition1,condition2),responce1,reponce2)

-----Original Message-----

.

So where is my original formula wrong? When I punch in the random number
1-6 it just puts the corresponding formula on the screen and does not
calcualte it i.e when I put it 1 D22 results in =0.2 instead of just
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

Hi
don't enclose the return values in apostrophes nor use the equation
sign

--
Regards
Frank Kabel
Frankfurt, Germany

"Wazza" schrieb im Newsbeitrag
...

So where is my original formula wrong? When I punch in the random
number
1-6 it just puts the corresponding formula on the screen and does not
calcualte it i.e when I put it 1 D22 results in =0.2 instead of just
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