Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting excel formula to vfp syntax
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Converting excel formula to vfp syntax
Miscellaneous
Thread ID:
00948632
Message ID:
00948632
Views:
64
Hi All,
i need convert this excel formula to vfp syntax

A1 range value 456.548.313

excel formula in B1 range

=((A1-(RIGHT(A1;4)))/1000000)+((IF(((RIGHT(A1;4))-5000)>=0;1;0))/100)

B1 range result : 456,55

how would be the vfp syntax for the same result in vfp ?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform