Forum Discussion

MikeH2021's avatar
MikeH2021
Copper Contributor
May 28, 2021

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

 

Share

Resources