Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting excel formula to vfp syntax
Message
From
04/10/2004 16:57:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00948632
Message ID:
00948639
Views:
16
>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


lnTL = 456548313
lnYTL = ROUND(lnTL/1000000,2)
? lnYTL

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform