excel help please...

  tnelis 10:45 13 Jan 05
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 05

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 05

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

  tnelis 12:05 13 Jan 05

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 05

In C1

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

  tnelis 13:17 13 Jan 05

Great stuff....thanks to all!

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now