If function with 3 different outcomes
You should consider using Copy/Paste to put posted formulas and/or code into
Excel instead of relying on typing what you (think you) read from the
screen.
--
Rick (MVP - Excel)
"Max" wrote in message
...
I may have typed in wrong, however, excel corrected my mistake and the
formulas worked. Truely appreciate the help Pete, saved me a lot of time
just
now. take care
"Pete_UK" wrote:
You could do this:
=IF(E17<C17,"Below range",IF(E17D17,"Above range","In range"))
Assumes that C17 is less than D17.
Hope this helps.
Pete
On Jul 31, 1:44 am, Max wrote:
How to use the IF function to get 3 different outcomes. If E17<C17 then
"Below Range", If E17D17 "Above Range" IF E17 is between between C17
AND D17
then In Range.. How do i do this?
|