Check all the SUM and if the value is unique then Plot

[thilag]

Hello Friends

Ms Excel : 2010, Please refer the attached file <Check and plot the value.xlsx>

I want to check the all the sums and the K3 Value, if it is equal then plot the value in E4, otherwise plot as "Check"

1) K3 value
2) SUM(E6:E7)
3) SUM(E9:E13)
4) SUM(E15:E16)
5) SUM(E18:E19)
6) SUM(E21:E22)

If all the values is equal i.e., K3 = SUM(E6:E7) = SUM(E9:E13) = SUM(E15:E16) = SUM(E18:E19) = SUM(E21:E22)
then plot the value, if not then plot "Check"

I my self return the formula using IF and AND but it is not working
For check the formula even if i changed the value in the any (leads to sum) cell to make the unequal values and to plot `Check' still it shows value.

I could not able to find where i made a mistake.

thanks

thilag

[Fotis1991]

1 way

=IF(AND(E6+E7=SUM(E9:E13),E6+E7=E15+E16,E6+E7=E18+E19,E6+E7=E21+E22),SUM(E6:E7),"check")

[Max, Singapore]

Try in E4:
=IF(AND(SUM(E6:E7)=K3,SUM(E9:E13)=K3,SUM(E15:E16)=K3,SUM(E18:E19)=K3,SUM(E21:E22)=K3),K3,"Check")
--------------------------------
Any good? Yes? Hit the little star at the bottom left of my responses

[sktneer]

May be this......

K3 =IF(AND(SUM(E6:E7)=SUM(E9:E13),SUM(E9:E13)=SUM(E15:E16),SUM(E15:E16)=SUM(E18:E19),SUM(E18:E19)=SUM(E21:E22)),SUM(E6:E7),"Check")

Sorry I completely missed the question.
The correct one is as below......

E4 =IF(AND(SUM(E6:E7)=K3,SUM(E9:E13)=K3,SUM(E15:E16)=K3,SUM(E18:E19)=K3,SUM(E21:E22)=K3),K3,"Check")

[dredwolf]

I think you have forgotten the basic rule of logical arguments, you HAVE to test EACH argument for the condition individually, UNLESS the condition itself resolves to zero/not zero, so maybe this:

=IF(AND(SUM(E6:E7)=K3,SUM(E9:E13)=K3,SUM(E15:E16)=K3,SUM(E18:E19)=K3,SUM(E21:E22)=K3),K3,"Check")

Hope this helps

[thilag]

Hello All

thanks

Now i understood the problem in my formula.

thanks

thilag