Any mommies here that are Excel experts?

[mhaney03]

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.

[deccaf]

Which if function? What are you trying to do?

[mhaney03]

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]

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

[deccaf]

Glad you figured it out.