PDA

View Full Version : Excel IF's



Dannz
01-03-2005, 03:43 PM
i am trying to use an IF forumla but i cant quite get it working

IF B3 = 1 then A1 = 20
= 2 =15
= 3 =10
= 4 = 5

Dannz
01-03-2005, 04:11 PM
the formatting didnt work it should be
IF B3 = 1 then A1 = 20
IF B3 = 2 then A1 = 15
IF B3 = 3 then A1 = 10
IF B3 = 4 then A1 = 5

Steven
01-03-2005, 04:24 PM
Copy this formula to cell a1

=IF(B3=1,20,IF(B3=2,15,IF(B3=3,10,IF(B3=4,5,0))))

Dannz
01-03-2005, 04:44 PM
Thankyou it worked perfectly