Sign in to follow this  
Followers 0
cyb3r-dan

Excel 2007

7 posts in this topic

Hi

Does anyone know how to do a formula that detects that H3 says DG if it is true than add the price in cell I3 to the cell F33 if false do nothing, and then same but CP instead of DG, but doing this in the range I3-I15. so at the end it should give the total amount of all the cells in I3-I15 that says DG/CP into the total of cells F33/F34.

Hope i make sense ^_^

Daniel

0

Share this post


Link to post
Share on other sites

Try again. Don't use cell names/numbers, it's too confusing since we can't see the sheet. Just explain in plain English what you're trying to accomplish.

0

Share this post


Link to post
Share on other sites
Are you talking about IF and THEN statements? I assume that you are so try these links:

http://spreadsheets.about.com/od/tipsandfa...unction_faq.htm

http://pubs.logicalexpressions.com/Pub0009...icle.asp?ID=242

Sorry i thought i would be confusing but t3st.s3t got the jist.

what i want to do is i have a column that says DG or CP then next to that there is a column of money, if it say DG i want it to add the money next to it, to another total cell, and then the same for CP

Thanks

Edited by cyb3r-dan
0

Share this post


Link to post
Share on other sites
Are you talking about IF and THEN statements? I assume that you are so try these links:

http://spreadsheets.about.com/od/tipsandfa...unction_faq.htm

http://pubs.logicalexpressions.com/Pub0009...icle.asp?ID=242

Sorry i thought i would be confusing but t3st.s3t got the jist.

what i want to do is i have a column that says DG or CP then next to that there is a column of money, if it say DG i want it to add the money next to it, to another total cell, and then the same for CP

Thanks

It's a matter of if and then statements. Look at the links that I posted for you carefully, because there are some examples that are similar to what you want to accomplish. It's a little complicated to go over here. PM me if you want and I'll help you as best as I can.

0

Share this post


Link to post
Share on other sites

ye that is simple,it is called the IF statement

=IF((500=>200),"True","False")

that is a typical example of it

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0