View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Multiple ifs and formulas

hi
try this...
=IF(A124,A1*0.9,IF(A10,A1*0.7,""))


regards
FSt1

"NeSchw6G" wrote:

I need help building a formula for this:
if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is
between 25-29 then mulitply cell B1 by .09

Thank you