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)

This should work:

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

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

Hi Roy..

Thank you for your time.

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.