30 Something Moms

Featured Posts
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

Active Posts in All Groups
More Active Posts
Featured Posts in All Groups
More Featured Posts
close Join now to connect to
other members!
Connect with Facebook or Sign Up Using Email

Already Joined? LOG IN