May 13 2023 09:10 PM
Can anyone help with a format for Excel that can do this: I want to look at a value and if it's greater than say, 1, then I want it to return "1" - BUT, if it's greater than 2, I want it to return "2", greater than 3, then return "3", etc.
Is there a formula configuration that can do that?
May 13 2023 09:29 PM
@Kandor5 Please explain a bit more. Let's say the number is 3. That's both greater than 1 and 2. What should be the result.
May 14 2023 01:13 PM
May 14 2023 01:28 PM
May 14 2023 02:35 PM
I thought about =INT(A1) and =ROUNDUP(A1,0) but then for value 0f 3 it returns 3 instead of 2 (since >2 and !>3) and same for 2.
However, Kandor5 might be looking for this solution...Thanks