Thread
:
IF function displays wrong amount
View Single Post
#
3
Myrna Larson
Posts: n/a
Look at your formula a bit harder. Before you even get to the IF test, you
calculate this amount and add it to the result of the IF test.
On 5 Nov 2004 12:36:15 -0800,
(JAnderson) wrote:
Hello all,
I have an IF function to calculate Federal Tax. In the Function Arguments
Dialog Box the logical test = True, and the Value_if_true = 303.7605, which
is
what I want. The Value_if_false = 0, which is also what I want. The formula
result in the bottom left of the dialog box however = 607.52. Double what it
should be. I have uploaded a screenshot here
http://home.earthlink.net/~janderson3/
Any suggestions as to what I'm doing wrong would be appreciated.
Thanks in advance.
J Anderson
Reply With Quote