on 15-12-2014 05:56 PM
why would the C column be =SUM(b1/a1) ? surely it would be just =b1/a1 with the C column formatted as a Percentage? Maybe I'm missing something?
why would the C column be =SUM(b1/a1) ? surely it would be just =b1/a1 with the C column formatted as a Percentage?
Maybe I'm missing something?
15-12-2014 06:29 PM - edited 15-12-2014 06:30 PM
15-12-2014 08:42 PM - edited 15-12-2014 08:43 PM
The caculation sort pf falls apart if you ordered 0 ans got sent some
But you are ahead anyway 🙂
on 15-12-2014 09:10 PM
You can get around the 0 in cell A if you put this in cell C
=IF(A1<=0,"Yipee a freebie",B1/A1)
