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

IF B3 = 1 then A1 = 20

= 2 =15

= 3 =10

= 4 = 5

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

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

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))))

=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

Powered by vBulletin® Version 4.2.5 Copyright © 2020 vBulletin Solutions Inc. All rights reserved.