Thanks Tom.

Worked fantastic.

=IF(H39="short",SUM(M39-L39),IF(H39="long",SUM(L39-M39)))/100

Thanks again.
John.

--
View this message in context: 
http://nabble.documentfoundation.org/Decimal-Point-Move-tp3260784p3260861.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to