Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
decision Box Y
How do i put a formula that recognises a 'yes' or 'no' answer?
e.g X Y Z 1 10,000 No 0.000 If Y1 has 'No' printed in it then 0.000 is printed in Z1 However if 'Y1' has 'yes' printed in it I need a formula of =sum(X1*0.03) to be completed (see below). e.g X Y Z 1 10,000 yes 300 Can anybody help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
decision tree in excel??? | Excel Discussion (Misc queries) | |||
Decision Tree Add-In? | Excel Worksheet Functions | |||
Decision Matrix with multiple criteria and decision | Charts and Charting in Excel | |||
Help with decision | Excel Discussion (Misc queries) | |||
How to I make a decision using excel? | Excel Discussion (Misc queries) |