Link to home
Start Free TrialLog in
Avatar of Kevin
KevinFlag for United States of America

asked on

help with a excel 2010 formula

Hello,

I need help with an excel formula.

I am trying to use the below formula:

=IF(D3,D4 = 0, "PLEASE ORDER 4 TONERS", "")

So if both cell D3 and D4 have a value of 0 a message (PLEASE ORDER 4 TONERS) will appear in the cell with the formula.

But i am recieveing an error saying that ive entered too many arguments for this function.

If I make the formula like this:

=IF(D3,D4 = 0, "PLEASE ORDER 4 TONERS")

The formula works fine and and when both values are at 0 it will display the message. But when both of the values dont equal 0 i get a value of "TRUE" which i dont want, as if both cells dont equal 0 i want the value in the box to display nothing.

Please advise how i can make this work.

Regards,
N
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kevin

ASKER

Thank you.