Help with Value percentage calculation

1. Help with Value percentage calculation

I need a formula to perform the following functions please:

If value in cell (A1) is less than 80% of 78.0 the formula return should be zero.
If between 80%-85% of 78.0 to return (1000).
If between 86%-90% of 78.0 to return (2000).
If between 91%-95% of 78.0 to return (3000).
If between 96%-100% 78.0 to return (4000).
If above 100% of 78.0 to return (5000).

Example:
Time value entered in cell (A1) is 71.76, the needed formula should returns (3000)

2. Re: Help with Value percentage calculation

Try this...

Formula:
`Please Login or Register  to view this content.`

3. Re: Help with Value percentage calculation

This should work:

=LOOKUP(A1/78,{0,0.8,0.85,0.9,0.95;1};{0;1000;2000;3000;4000;5000})

4. Re: Help with Value percentage calculation

Unfortunately LOOKUP function is not supported by my apple app.

Can you please replace it with one of the supported functions from the following link?

http://support.dataviz.com/support_i...l#dtg_iphone21

5. Re: Help with Value percentage calculation

Hi khaldon..

Please spend some time.. to update your profile.. and post question in appropriate section

Your profile says Excel 2007, and you have posted in Excel Formula & Function section.. and you have not mention office version in your post..
It may increase your and our time..

BTW.. try this..
Formula:
`Please Login or Register  to view this content.`

6. Re: Help with Value percentage calculation

Hi Roy..

My profile is up to date, I am still using Excel 2007, however I will be using this spesfic formula with my apple app.

Reference to the link, from my previous post, I am sorry but even the VLOOKUP function is not part of the supported functions.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1