Forum Discussion
Solved
looking for function that can hlep me with work
Dear all Anyone can help me to which function can I used to solved the problem, I am trying to type equation which is { =IF (A3 => 334 to 999 ,"<300E+00 cfu/g or ml" ) } So, instead of...
When
=IF((A3>=334)*(A3<=999),"text1",IF((A3>=1000)*(A3<=9999),"text2",""))
maybe this one works... =if(A3>=334;if(A3<=999;"true")
Thank you for replay
even this did not work
What I would say to Excel ( if the number in A3 between 334- 999) give me text (<300E+00 cfu/g or ml).
And
( if the number in A3 between 1000 - 9999) give me text (<300E+01 cfu/g or ml).