Thread: Circular Reference Problem Calculating Net Pay
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gerard Gerard is offline
external usenet poster
  
Posts: 3
Default Circular Reference Problem Calculating Net Pay

Dave F wrote:
What formula are you currently using?

=FLOOR(x,5)

Rounds the net pay to the nearest (lowest) $5 multiple. But then how
can I re add this to the tax amount and calculate a new net figure?

Reply With QuoteReply With Quote