| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What if formulas and calculations - not true/false
I need to create a calculation based upon a number of fields e.g.
A1 = Y or N B1 = Y or N C1 = 32 D1 = a number E1 is for the result Required: If A1 = Y and B1 = Y then E1 = C1 * D1 else E1 = D1 All I can get is FALSE if either A1 or B1 is not Y but is both are Y then I get the correct result |
|
#2
|
|||
|
|||
|
=IF(AND(A1="Y",B1="Y"),C1*D1,D1)
-- Kind Regards, Niek Otten Microsoft MVP - Excel "BJS" wrote in message ... I need to create a calculation based upon a number of fields e.g. A1 = Y or N B1 = Y or N C1 = 32 D1 = a number E1 is for the result Required: If A1 = Y and B1 = Y then E1 = C1 * D1 else E1 = D1 All I can get is FALSE if either A1 or B1 is not Y but is both are Y then I get the correct result |
|
#3
|
|||
|
|||
|
One way:
E1: =IF(AND(A1="Y",B1="Y"),C1*D1,D1) In article , BJS wrote: I need to create a calculation based upon a number of fields e.g. A1 = Y or N B1 = Y or N C1 = 32 D1 = a number E1 is for the result Required: If A1 = Y and B1 = Y then E1 = C1 * D1 else E1 = D1 All I can get is FALSE if either A1 or B1 is not Y but is both are Y then I get the correct result |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas don't calculate until SAVE (excel 2000) | Excel Discussion (Misc queries) | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| Protecting Formulas | New Users to Excel | |||
| workbook size and calculations | Excel Worksheet Functions | |||
| Updating calculations + graph when i enter in new data WITHOUT OFF | Excel Worksheet Functions | |||
Linear Mode
