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