Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet and I have a cell that calculates tax. the formula for
that cell works. but I want it to calculate the tax if in another cell i put a y and to not calculate if I put a N. if I do say it non taxable I want a value of $0.00 the tax cell is a currency format. here is my tax formula (located in colum N) =SUM(C3,I3,E3,J3,)*8.5% In Cloum M I want to put a "y" or "n" if it is taxable or not |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate sum of values based on a ref value, how? | Excel Discussion (Misc queries) | |||
How do I calculate a value based on dates? | Excel Discussion (Misc queries) | |||
how to calculate based on dates? | Excel Discussion (Misc queries) | |||
calculate based on color | Excel Discussion (Misc queries) | |||
How do I calculate the age of a subject based on their DOB? | New Users to Excel |