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.
October 8, 2012 at 11:41 PM
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?
October 9, 2012 at 12:04 AM
HA I figured it out... OMG.. my brain is just not working right today.