Forum Discussion
formula If... Then
Hi - I am trying to write a formula for cell B1 if the value in cell A1 is between 0 and $10 then B1 = $1 if the value in cell A1 is greater than $10 and less than or equal to $25 then B1 = $2 if ...
MikeH2021 Try this:
I've used named ranges to make the formula easier to read and maintain.
A working example in the attached file.