Dock Buddy Wrote:
I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it
by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x
it by
..14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the
figure
in cell 18. Please help!!!!!!!!!! Thanks
In cell K18 =if(and(h1870,h18<100),h18*0.19,"")
In Cell L18 =if(and(h18100,h18<300),h18*0.14,"")
In Cell M18 =if(h18300,h18*.0.12,"")
COMMENTS:
1. You can have one formula to satisfy all your given conditions.
2. Just curious, what happens during the following conditions?:
h18<=70
h18=100
h18=300
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=275149