What if formulas and calculations - not true/false

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
 
N

Niek Otten

=IF(AND(A1="Y",B1="Y"),C1*D1,D1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need "true" or "false" 4
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Adding cells proplem 2
distance calculations 1
Baffeling IF statement 7
Formula for If "" AND "" are true... 3
Time Calculations Help 4
Permutations andText to column problem 6

Top