tnelis 10:45 13 Jan 2005
Locked

Please, how do I write this formula properly?
If a1=1 and b1=2 then let c1=d1

Many thanks.

Gongoozler 11:01 13 Jan 2005

I'm no Excel expert, but I think this works. Enter this in cell C1. The value in C1 will then be 0 if A1 isn't 1 or B1 isn't 2. Otherwise C1 will be equal to D1.

=(D1)*AND(A1=1,B1=2)

end 11:15 13 Jan 2005

I suggest you need Vog; u might want to wait until he sees the thread:)

tnelis 12:05 13 Jan 2005

Gongoozler, this works perfectly.....but I need a final tweak please....if A1 isn't 1 and B1 isn't 2 how can I get C1 to equal Minus 1...?

Thanks,

VoG II 12:59 13 Jan 2005

In C1

=IF(AND(A1=1,B1=2),D1,-1)

tnelis 13:17 13 Jan 2005

Great stuff....thanks to all!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?