View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VT - Maryland VT - Maryland is offline
external usenet poster
 
Posts: 1
Default Commission - IF formulas

I need formula for commission of 25% if cell c22 is greater than $2,600. and
less than $4,499. I keep trying =IF(C224500,"0",IF(C22<2600,"c22*25%"))
with a value in cell c22 of $4,500, but I get the result of FALSE instead of
zero.