30 Something Moms

mhaney03
Any mommies here that are Excel experts?
October 8, 2012 at 11:18 PM

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.

Replies

  • deccaf
    by deccaf
    October 8, 2012 at 11:31 PM
    Which if function? What are you trying to do?
  • mhaney03
    October 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
    October 9, 2012 at 12:04 AM

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

  • deccaf
    by deccaf
    October 9, 2012 at 12:06 AM
    Glad you figured it out.

30 Something Moms