Mar 09 2022 07:45 AM
Hello all,
I was wondering if someone could help me with a quick function query.
I currently want the following equation;
if something is below 16mm, it will produce "275",
if something if between 16mm and 40mm, it will produce "265",
and if something is between 40mm and 60mm, it will produce "255".
This usually works but using multiple =IF() functions, however, when it is picking up a value from a =VLOOKUP cell, it will only pick up the IF FALSE section of the command.
The current formula I am using is
=IF(F182<16,"275",IF(40>F182>16,"265",IF(60>F182>40,"255",FALSE))) and at the moment, it is producing "265" even though the cell number it is picking up is 14mm.
If I use this formula with the same number (14mm) but manually typed into a cell, it will work.
I appreciate any feedback. Thank you.
Charlie
Mar 09 2022 07:51 AM
The formula should be
=IF(F182<16,"275",IF(F182<40,"265",IF(F182<60,"255")))
But do you really want to return a text value? If it should be a number, change the formula to
=IF(F182<16,275,IF(F182<40,265,IF(F182<60,255)))
Mar 09 2022 07:54 AM
Mar 09 2022 08:10 AM
Perhaps the VLOOKUP function returns a text value such as "57" instead of the number 57?
Mar 09 2022 08:57 AM
Mar 09 2022 08:59 AM
It depends on the formulas. Perhaps you can replace " with nothing in the cells with the formulas, if they don't contain other quotes...