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

=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

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