• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

if statement

A

adrief

New Member
HI

I have written a if statement to add two cells together (90+1120) if the first column is the same (CU08116) if not it should give me the value in column V but if it is the same in the first column the value of the second line must be 0. How do I finish this formula?


=IF(Q12=Q13,SUM(V12:V13,),V:V)
CU08116 HRC S/F HOOKS 90 1 31 90 1210
CU08116 HRC S/F 190 HYD COLLAR 112 10 386 1120 1120
 
Hi ,

Your problem description is not clear ; can you clarify the following ?

1. In which cell is this formula to be entered ?

2. What is the meaning of the following :
if not it should give me the value in column V but if it is the same in the first column the value of the second line must be 0.
Click to expand...
Narayan
 
Hi i have uploaded the file. i have highlighted the query lines in Orange
you will see that there is a MLOT number if this number is the same the =IF(N11=N12,SUM(S11:S12,),S:S) should be in column T. but i want the bottom figure of the same MLOT number to be 0 as it is already included in the line above.
 

Attachments

I'm confused
Above you say "but i want the bottom figure of the same MLOT number to be 0 as it is already included in the line above."

Thats what my formula does
upload_2016-3-23_22-24-38.png
 
You must log in or register to reply here.
Back
Top