Can you show me, please, how to write the IF formula for this example?

The generosity of your knowledge is greatly appreciated.


"Gary" wrote:

it is still confusing. the way i look at it, an IF formula should work.

"mrl" wrote in message
...
Column B represents a number from 95.0% to 99.5%, with each row a
different
number. To the right of Column B I need to have Excel fill in the
pre-designated number in the correct row; i.e. =95.0%<=95.49 should
result
in 200% appearing in H5 (since B5 shows 95%) then =95.5%<=95.99 should
result in 170% appearing in H6 (since B6 shows 95.5%).

The result of a simple formula, which resides in F29 will determine the
percentage rating used above, which is what needs to be either true or
false
to fit into the ranges as explained above?

I know I'm inexperienced in writing a complicated formula, and haven't
used
Lookup functions at all. I'm guessing that's what needed, not an IF
formula?

Please help?

--
The generosity of your knowledge is greatly appreciated.


"Bernard Liengme" wrote:

You will need to spell that out in more detail - at least for me!
Maybe make up an analogous example.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mrl" wrote in message
...
I need Excel to look in Cell F29 and populate (with one numerical value
from
F5:F14) only one of the series of cells H5:H14 dependent on results in
F29
falling between ranges set in B5:B14. I know the fomula needs to
reside
in
H5:H14, but the rest is over my head.

F29 is the result of C27/E27