IN CELL CALCULATIONS

[Guest]

DONT KNOW IF I CAN DO THIS BUT..

IM TRYING TO ADD A FORMULA INTO A CELL TO SPLIT THE NUMBER I PUT INTO THAT PERTICULAR CELL, FOR INSTANCE
IF I ENTER THE NUMBER 2 INTO A CELL I NEED IT TO THEN SPLIT THAT NUMBER INTO FRACTIONS, THIS IS SO I CAN CALCULATE MY FOOD STOCK, AS IF I NEED TO CHECK STEAKS FOR INSTANCE, I MAY HAVE ONLY SOLD HALF FOR A PERTICULUR MEAL SO IF I ENTER THAT 2 HAVE BEEN SOLD, I NEED THE CELL TO CALCULATE THAT IN TOTAL IVE ONLY SOLD ONE WHOLE STEAK...

 

[AlfD]

Hi!

It sounds to me as if you need to settle on a safe system of units. Fo
example, if the smallest unit of steak is half a steak, use that as th
basic unit. A whole steak is than 2 units, so you can enter exactl
what you use.

Excel won't have any way of deciding how to interpret a particula
entry unless you give it precise (idiot-proof, I usually say) rules t
work by. I can't see those rules in what you wrote .

"I MAY HAVE ONLY SOLD HALF" is not such a rule, for example.


Al