View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jorgecarrejo jorgecarrejo is offline
external usenet poster
 
Posts: 2
Default formula in excell 2007

Ok, I am trying to create a formula that will do the following:

If cell F2 has any number between 23 and 28, I want it to multiply cell E2
by 20%,
if it has 28.01 and 32, then I want it to multiply cell E2 by 25%. If it has
32.01- 40, then I want cell E2 to multiply by 30%. And so on.
I only want it to do 5 sets of this.

Can anybody help?
please email me at
Thanks,

Jorge