formula question

[Mel]

Hi,
Well I've looked in my excel books and I have excel for dummies (and yes I
need it) , I am sure there must be a way and have tried several things
hoping to hit on the right one.
I want a result in one cell, reliant upon two different cells having a
$amount over zero. I tried this formula but it only comes back with the word
"true" or "false" and only works for one cell with an amount over zero.
=OR((D4>0)*(G4>0),'TDBonus'!K3,0). In other words if D4 is more than zero or
G4 is more than zero, then I want the cell to display what is on another
sheet at K3, and if D4 and G4 are both zero then nothing will be displayed
in the cell. K3 on the sheet named "Bonus" has the letter"N" in it, so I
want the "N' to appear in the cell. D4 and G4 are dollar values if they have
anything in them. i.e. $45.00. I would appreciate any help.

Mel

 

[Bondi]

Hi Mel
Try

=IF(OR(D4>0,G4>0),'TDBonus'!K3,"0")

Regards,
Bondi

 

[Bill Ridgeway]

Mel,

Your formula was -
=OR((D4>0)*(G4>0),'TDBonus'!K3,0)

Try -

=IF(OR(D4>0,G4>0),'TDBonus'!K3,0)
(I haven't tested this fully)

Regards.

Bill Ridgeway
Computer Solutions

 

[Dave Peterson]

I would think that this would be more "natural":
=if(or(d4>0,g4>0),'TDBonus'!k3,0)

If both D4 and G4 had to be larger than 0:
=if(and(d4>0,g4>0),'TDBonus'!k3,0)

 

[Mel]

OH THANK YOU EVERYONE