Try something like ..

In K18: =IF(AND(H1870,H18<=100),H18*0.19,"")
In L18: =IF(AND(H18100,H18<=300),H18*0.14,"")
In M18: =IF(H18300,H18*0.12,"")

Above assumes that blanks: ""
are to be returned if the criteria is not met
(the value_if_false)

Also, assumptions to plug the gaps in the specs,
(value in H18 equal to either: 100, 300)
have also been made (adjust to suit if incorrect)
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Dock Buddy" <Dock wrote in message
...
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