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