Kevin
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER