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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…