excel question

[*mrgrizz*]

how do i do the following % sum in excel

a=cartons ordered,b=cartons supplied

a=100cartons,b=100 cartons...show as 100%

a=100 cartons,b =90 cartons...show as 90%

a=100 cartons,b=110 cartons..show as 110%

TIA

[rabbitearbandicoot]

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?
 

[aps1080]

I think you end up with the same thing.

I use the epsilon symbol - i think that is what it is called.

[poddster]

The caculation sort pf falls apart if you ordered 0 ans got sent some

But you are ahead anyway 🙂

[poddster]

You can get around the 0 in cell A if you put this in cell C

=IF(A1<=0,"Yipee a freebie",B1/A1)