Prev: Can multiple criteria be used for IF formulas?
Next: How do I get a sum of every seventh cell in a column?
From: CHaney on 25 Feb 2010 10:27
I am using the below formula to calculate percent of change from one year to
another year.

=IF(F3=0,1,U3/F3-1)

F3 being the amount spent in previous year
U3 being amount spent in current year

The question I want my formula to answer is: If F3 and U3 have a quotient
greater than zero, then calculate. However, I also want it to yield a 100
answer if the F3 is zero AND I also want it to yield 0 if both F3 and U3 are
zero.
--
Thanks, Christine
 | 
Pages: 1
Prev: Can multiple criteria be used for IF formulas?
Next: How do I get a sum of every seventh cell in a column?