Forum Discussion

hookvikes's avatar
hookvikes
Copper Contributor
Sep 08, 2020

Excel Help with IF and Greater than less than

Not sure what the best formula is for this, any help or suggestions would be appreciated!   You can see what I'm trying to accomplish with the formula I have so far.   Feel Free to download my at...
Formulas and Functions
hookvikes's avatar
hookvikes
Copper Contributor
Sep 08, 2020

SergeiBaklan 

That is good help, but it only changes when those hit exactly.

I need LESS THAN 180,

Then = or greater than 180 to less than 240

then = or greater than 240 to Less than 300

then = or greater than 300 to less than 350

then = or greater than 350

that way when the numbers hit in between any of these, i can get the correct calculation.

Thanks for the help! 

Resources