LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lani Jo
 
Posts: n/a
Default Computing Sales Tax and Retail Price from a number

Hello All,

The situation is this...

When given a new product, the user is given the price to a customer
which includes sales tax. This number is typically a simple number such as
50.00 or 20.00.

The issue is that the *system* requires that retail price and sales tax are
entered separately, such as Retail Price 18.56 + Sales Tax 1.44 = Total Price
20.00.

While I know I learned this reverse calculation somewhere in past, I cannot
remember it now, which is preventing me from creating the formula.

Please help.
Thanks in advance.

Lani
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"