Hi,
Can someone help me determine what is wrong with the following statement:
=IF(Y128>X128,W128)*(OR(Y128=0,0,(W128/X128*Y128)))
I am trying to create a function that recognizes 2 arguments in one statement/function.
I want excel to calculate using the following arguments:
1. If (column Y) is greater than (column X) then result should be (column W) OR
2. IF (column Y) is = zero then result should be zero, or else divide (column W) by (column X) and multiply by (column Y)
Thank you
Bookmarks