Thread: I Need Help
View Single Post
 
Old 08-03-2011, 04:36 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi Robbie

Try this formula, it should be self explanatory as to how to change the multiplier to what you want:

=IF(A1<10.01,A1*10,IF(A1<50.01,A1*20,IF(A1<100.01, A1*30)))

Tony (OTPM)
Reply With Quote