Thread: If formulas?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dale Dale is offline
external usenet poster
 
Posts: 92
Default If formulas?

I'm trying to create a formula to give me the following:

$1.00-30.00=1.46
30.01-60.00=4.35
60.01-89.00=8.70
89.01-119.00=12.16
119.01-147.00=19.54
147.01-178.00=23.88
178.01-206.00=28.22
206.01-236.00=32.56
236.01-295.00=39.07
295.01-354.00=54.11
354.01-413.00=75.23
413.01-471.00=86.81
741.01-530.00=122.98
530.01-590.00=130.22

Can anyone help??...Thank You