What if formulas and calculations - not true/false

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top