Finding a value from a division

[gach]

Hi,

How can I find the right value per print if a toner costs 25,00€ and can print 2000 sheets?

[PKowalik]

It's 25/2000 = 0.0125 €/sheet or 1.25 cents/sheet.
BTW, what your question has to do with Excel? It's mathematics on a very elementary level.

[gach]

If I set =L4/500 (L4 being 6.00), it gives 0,01 € which is not a mathematically accurate result and that is why I need help from people who understand Excel
+

[PKowalik]

If you use the currency format (with € symbol preceding or following the number), then by default you have the result rounded to two decimal digits (after comma or dot, whatever decimal sepataor you are using). Change the format of the cell and you'will see something like 0.012 €.

[TMS]

The underlying value doesn't change but the formatting makes a difference to what you see.

Please Login or Register  to view this content.