This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I'm extremely new to sheets/excel, so apologies if my formatting or jargon is lacking.
I'm working on something to calculate a range using two cells. To help clarify, it's determining an encumbrance level using a "weight" cell(S8) and a "basic lift" cell (D9). The final cell will calculate which range the weight puts me at. This is what I'm using. It functions as intended for levels 0 and 1, but it does not move up to levels 2,3,4 once the weight goes up. This is what I have so far:
=IF(S8<=D9,0,IF(D9*3>=S8>D9*2,1,IF(D9*6>=S8>D9*3,"2",IF(D9*10>=S8>D9*6,3,IF(S8>D9*10,4)))))
S8(weight)
0-20=level 0
21-40=level 1
41-60=level 2
61-120=level 3
121-200=level 4
I'm not sure if that helps, but I can provide more info if needed.
Subreddit
Post Details
- Posted
- 4 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/googlesheet...