Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy[_10_] Tommy[_10_] is offline
external usenet poster
 
Posts: 2
Default Formula Help

I would like to take a value in a cell (B3) and perform the following
calculation and record in cell (B4)

If B3120, then subtract 20 and multiply the result by 1.08.
If B3<=120 then multiply B3 by 1.08.

Any assistance is appreciated

Thanks!
Tommy