I’m trying to calculate the number of digits after the decimal point so that I can turn the total into a whole number.
Example: I have this data.

buy 0,69513 0,69614

buy 75,293 75,331

sold 37,44 37,58
In row one I have the formula
=IF(C28="buy";E28D28;IF(C28="sold";D28E28;0))
If I try
=IF(AND(C29="buy";"0,000000);*10000);E29D29;IF(AND(C29="sold";0,00000);*100000;0"))
[erAck: made the formula a code block by breaking it into a new line and hitting Ctrl+K which indents it by 4 spaces; turns out the embedded *
asterisks were munged in the flow text display as they are control characters for emphasized text]