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 ( to ) which formal can I used ?
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).
Hi,
If in plain text do you mean
if A3 >= 334 and A3 <= 999 then <my text> else ""
or what?
Thank you for replay
But it’s 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).
When
=IF((A3>=334)*(A3<=999),"text1",IF((A3>=1000)*(A3<=9999),"text2",""))
