SOLVED

I need help with a formula

Copper Contributor

I am trying to write a formula to convert a % in cell D3 into a 0 or 3 based on if D3 is >1.

 

So if D3 is >1 then zero, if it is <1 then 3

 

I keep getting a 3 no matter what i enter into D3 as a test number.

2 Replies
best response confirmed by Mikedgw1 (Copper Contributor)
Solution
I'm sure you know but just in case, 100%=1 so if you are testing numbers like 1,2,3 % then all of those numbers are <1 (<100%). Did you try a number like 200?
I assume your formula looks something like this:
=IF(D3<1,3,1)
I believe you just solved my problem. I knew what you just said but the cell with the % in it needs to be viewed as is. So i assume the easiest solution would be to change the formula to <.01. I am going to test that now.
1 best response

Accepted Solutions
best response confirmed by Mikedgw1 (Copper Contributor)
Solution
I'm sure you know but just in case, 100%=1 so if you are testing numbers like 1,2,3 % then all of those numbers are <1 (<100%). Did you try a number like 200?
I assume your formula looks something like this:
=IF(D3<1,3,1)

View solution in original post