View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default need help with formula

I used
=IF(A141100,(A1-41100)*6%+(41100*4.5%),A1*4.5%)

Some notes and ideas: you can use cell references in place of the
41100, the 6%, and the 4.5% and enter those values in those cells,
rather than hardcode them.