Join the Meeting Place for Moms!
Talk to other moms, share advice, and have fun!

(minimum 6 characters)

# Any mommies here that are Excel experts?

Posted by on Oct. 8, 2012 at 11:18 PM
• 4 Replies

I'm having issues with making a formula using the IF function... I can't figure out how to do it without making a circular reference or creating an extra column/step.

by on Oct. 8, 2012 at 11:18 PM
Add your quick reply below:
You must be a member to reply to this post.
Replies (1-4):
by Bronze Member on Oct. 8, 2012 at 11:31 PM
Which if function? What are you trying to do?
Posted on CafeMom Mobile
by on Oct. 8, 2012 at 11:41 PM

Quoting deccaf:

Which if function? What are you trying to do?

Column A is unit purchase price, Column B is quantity, Column C is %discount. I need to make the next column a total of each sale. Wouldn't the IF fuction work being that half of the discounts are 0% and this is a formula I need to apply to entire column?

by on Oct. 9, 2012 at 12:04 AM

HA I figured it out... OMG.. my brain is just not working right today.

by Bronze Member on Oct. 9, 2012 at 12:06 AM
Glad you figured it out.
Posted on CafeMom Mobile
Add your quick reply below:
You must be a member to reply to this post.
30 Something Moms
Join the Meeting Place for Moms!
Talk to other moms, share advice, and have fun!

(minimum 6 characters)

close Cafemom Join now to connect to other members! Connect with Facebook or Sign Up Using Email

Already Joined? LOG IN