excel help please...

  tnelis 10:45 13 Jan 05

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.


  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...?


  VoG II 12:59 13 Jan 05

In C1


  tnelis 13:17 13 Jan 05

Great stuff....thanks to all!

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac