=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
|