Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF...AND...OR...Statement
I have the following formula, which does not work
=IF(OR(P28="Yes"),AND(W28=V28,D28-V28),OR(W28<V28,D28-W28,IF(P28="no",0))). What I need is as follows: If P28 is "Yes" and IF W28 is equal to V28, then D28 Minus V28, OR If P28 is "Yes" and W28 is less than V28, then D28 Minus W28, If P28 is "No", then 0. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If Statement | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |