Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
If I have a cell with Y and anothe with N and need to do a formula to
say if it is Y then that cell s/b $200.00 but if that cell is N then that cell s/b $0.00 how do I create such a formula? This tests test A1 for Y or N, returning 200 or 0: =CHOOSE(FIND(A1,"YN"),200,0) Format as desired. To provide for a different value in A1 by error, one might expand this to: =IF(ISERROR(FIND(A1,"YN")),"Should be Y or N", CHOOSE(FIND(A1,"YN"),200,0)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |