Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
Hi,
I have 5 conditions in an IF formula and I just cant get it right. Im trying to display a % in cell D10. D10 must display 1% if F12 has the value between 200000 and 249999. D10 must display 2% if F12 has the value between 250000 and 299999. D10 must display 3% if F12 has the value between 300000 and 349999. D10 must display 4% if F12 has the value between 350000 and 399999. D10 must display 5% if F12 has the value is 400000 and above. Thanks, Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Look up question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
iif question | Excel Discussion (Misc queries) |