LinkBack URL
About LinkBacks
Because of the regularity of your data, you can also use this formula to give the same results as the array formula:
=MROUND(F3-1,500)*0.2
If you want the equivalent of the second formula that I gave you, just remove the -1.
Hope this helps.
Pete
Because of the regularity of your data, you can also use this formula to give the same results as the array formula:
=MROUND(F3-1,500)*0.2
If you want the equivalent of the second formula that I gave you, just remove the -1.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks