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

(minimum 6 characters)

30 Something Moms 30 Something Moms

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):
deccaf
by Bronze Member on Oct. 8, 2012 at 11:31 PM
Which if function? What are you trying to do?
Posted on CafeMom Mobile
mhaney03
by Bronze Member 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?

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

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

deccaf
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.
Join the Meeting Place for Moms!
Talk to other moms, share advice, and have fun!

(minimum 6 characters)