N
Newsgal
I'm need to include the IF 0,0 formula in the formula below.
In this formula, C29 = Sales Goal, D29 = Sales Achieved, and E29 returns the
results. The formula is set up to account for times when there is a zero
goal, but a sale $ amount which means the sales rep gets 100% in E29 or, if
there is both a goal and sales acount they get the percentage of sales to
goal. However, when there is neither a goal or sales, the E29 result can't
return a #DIV/0! or the total cell that E29 rolls up into won't function
correctly. Help!
=IF(AND(C29=0,D29>0),100%,D29/C29)
In this formula, C29 = Sales Goal, D29 = Sales Achieved, and E29 returns the
results. The formula is set up to account for times when there is a zero
goal, but a sale $ amount which means the sales rep gets 100% in E29 or, if
there is both a goal and sales acount they get the percentage of sales to
goal. However, when there is neither a goal or sales, the E29 result can't
return a #DIV/0! or the total cell that E29 rolls up into won't function
correctly. Help!
=IF(AND(C29=0,D29>0),100%,D29/C29)