Thread: How do I figure out a pre-tax amount when I know the final total?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RichardSchollar
 
Posts: n/a
Default How do I figure out a pre-tax amount when I know the final total?

If you have:

A times (1-B) equals C

where A is gross, B is tax rate (say 30%) and C is net (say $70) then
it follows that:

A = C/(1-B)

or A = 70/(1-0.30)

A=100

Does this help you with your problem?

Richard


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=546206

Reply With QuoteReply With Quote