Simple Formula

[Ralphnet]

Hi, I have a $55.00 Lease in cell E-9, In the ajoining cells F-9 + F-10 (merged) I want to be able to enter a number 1 thru 11. I need a formula for E-9 that will subtract $5.00 from the $55.00 per x the number unit entered(1 2 3 4 5 6 7 8 9 10 11). Thanks, Ralph



E-9 F-9+10
LEASE $55.00 HOURS OFF FOR DISCOUNTED LEASE

[/img]

 

[wongm003]

in E9 -> =55-(5*F9)

 

[Ralphnet]

THANK YOU 003 Ralph