ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   writing if formulas (https://www.excelbanter.com/excel-worksheet-functions/121479-writing-if-formulas.html)

mafarmer

writing if formulas
 
I am trying to write a formula and need help. (Calculating tax witholding
formulas) Example: If 8C times 19.23 minus 10C equals 401 to 450 then subract
4.60 plus a certain % of the difference between two numbers and enter that
number here, if it equals 451-500 then subtract 5.50 plus a certain
percentage of the difference between two numbers and enter that number and so
on according to the tax chart. There are several scenerios to enter in that
one cell.

Don Guillett

writing if formulas
 
http://groups.google.com/groups?as_d...a&as_uauthors=
or tinyurl

http://tinyurl.com/y5l4qv

--
Don Guillett
SalesAid Software

"mafarmer" wrote in message
...
I am trying to write a formula and need help. (Calculating tax witholding
formulas) Example: If 8C times 19.23 minus 10C equals 401 to 450 then
subract
4.60 plus a certain % of the difference between two numbers and enter that
number here, if it equals 451-500 then subtract 5.50 plus a certain
percentage of the difference between two numbers and enter that number and
so
on according to the tax chart. There are several scenerios to enter in
that
one cell.





All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com