MikeH2021
May 28, 2021Copper Contributor
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 the value in A1 is greater than $25 and less than or equal to $40 then B1 = $3
etc
The last one will be if the value in A1 is greater than $50 then B1 = $5
My preference is that the $ values 1, 2, 3, 4, 5 and 10, 25, 40, 50 etc are hard entered into data cells to allow simple change of the parameters and values at a later date
Can anyone help.
Ta Mike