Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on Y or N Values
Tax calculations to be calculated @ 10% unless an adjacent cell contains "N"
to indicate no tax is to be calculated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on Y or N Values
=IF(B1="N","",A1*10%)
or =IF(B1="N",0,A1*10%) depending on whether you want a blank or a zero if no tax. -- David Biddulph "Malcolm McMaster" wrote in message ... Tax calculations to be calculated @ 10% unless an adjacent cell contains "N" to indicate no tax is to be calculated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on Y or N Values
Try this:
A1 = 100 B1 = N or empty =(B1<"n")*0.1*A1 -- Biff Microsoft Excel MVP "Malcolm McMaster" wrote in message ... Tax calculations to be calculated @ 10% unless an adjacent cell contains "N" to indicate no tax is to be calculated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALCULATION BASED ON MORE THAN TWO CONDITIONS | Excel Discussion (Misc queries) | |||
Sum calculation based on condition | Excel Worksheet Functions | |||
Calculation based on 2 cols | Excel Discussion (Misc queries) | |||
Calculation based on date | Excel Discussion (Misc queries) | |||
Calculation based on a condition | Excel Worksheet Functions |