Hello, How do I formulate if A1 is bigger or equal to B1 but smaller than C1 ? Thanks
G Giunti34 New Member May 30, 2020 #1 Hello, How do I formulate if A1 is bigger or equal to B1 but smaller than C1 ? Thanks
L Logit Active Member May 30, 2020 #2 =IF(A1>=B1<C1, what should happen here , else what should happen here)
G Giunti34 New Member May 30, 2020 #3 Thanks but it's giving an error. This is the formula I typed in. Where's the error ? =IF(G1236>=J1236<I1236,"data2","data1")
Thanks but it's giving an error. This is the formula I typed in. Where's the error ? =IF(G1236>=J1236<I1236,"data2","data1")
L Logit Active Member May 30, 2020 #4 Understand you cannot enter the Formula in G1236. That is the cell value you are testing.
G Giunti34 New Member May 30, 2020 #5 I'm not entering the formula in G1236. I'm entering it in a different cell ( M1236 ) and I want it to say " data 2 " if G1236 is bigger or equal to J1236 and smaller than I1236.
I'm not entering the formula in G1236. I'm entering it in a different cell ( M1236 ) and I want it to say " data 2 " if G1236 is bigger or equal to J1236 and smaller than I1236.