Excel Formula Question - Need to verify totals

[Transition]

What i'm doing here is creating sales reports for our company. Since i have so many figures and a lot of room for error - i want to do a simple validation check to return a value (e.g. True or False).

Basically i have three cells which all contain dollar amounts. All i want to be able to do is say "Cell A + Cell B = Cell C Else True, False"

If A+B = C i just want it to say "True" and if A+B does not equal C i want it to say False.

I know this should be pretty dang easy - but i can't pinpoint where this is at in my Excel book.

Thanks everyone!

 

[NeoV]

I got you...


lets say your data is in columns A, B, and C

The formula in column D would be =if((a1+b1)=C1,"True", "False")

for "if" statements, the layout is =if(expression, if true, if false)


Note that you can "nest" if statements within other "if" statements, to allow for more than one expression to be checked...an example would be :

=if(a1=b1,"yes",if(a1=c1,"yes",if(a1=d1,"yes","no")))

This would let you check to see if the value in cell a1 is equal to b1, c1, or d1, and if none of those were true, it result would be the "no" in the last part of the last "if" statement!

Let me know if you have any other questions about this!

Later Trans!

 

[Transition]

You're the best Neo! 🙂

 

[Transition]

Ok i got the function to work with this formula....

=IF(('Sales Report'!B43+B63)='Sales Report'!B23,"Correct Total","Incorrect Value Entered")



But if i try to use the SUM function in this formula i get an error...

=IF(('Sales Report'!(SUM(stock_gp_dollars_2002))+(SUM(direct_gp_dollars_2002)))='Sales Report'!(SUM(gp_dollars_2002)),"Correct Total","Incorrect Value Entered")



I'm using a seperate worksheet to do all my validation in - and i'm referencing back to a range of named cells in 'Sales Report'. It keeps coming back telling me i have an error in the "SUM" function. What am i missing?

 

[CPA]

Try putting the SUM before Sales Report ex. =IF(((sum('Sales Report'!stock_gp_dollars_2002))+(sum('Sales Report'!direct_gp_dollars_2002))=Sum('Sales Report'!gp_dollars_2002)),"Correct Total","Incorrect Value Entered")

Check my parenthesis, not sure if they're exactly right.