IF formula

[weegieavlover]

Hi All,

I thought this was going to be an easy one for me but, alas, it was not meant to be:

My logic is:
if D3 = "added"
TRUE = Value in cell B3
FALSE = 0

so my formula is:
=IF(D3="ADDED",=B3,0)

But there is an error in the formula I have tried putting "" round the B3 but still does not work.

What am I missing?

 

[njimack]

=IF(D3="ADDED",B3,0)
You had a redundant equals sign in there

 

[weegieavlover]

=IF(D3="ADDED",B3,0)
You had a redundant equals sign in there

Champion - easy when you know how - thanks.