If function

[PaMart]

I would like a function that does the following.
If the target cell is empty = nothing
If between 1 and 35 = .1
If 36 = nothing
If 37 or over = the word "Count"
It's just beyond me

[Sam Capricci]

how about this...
=IF(OR(A2="",A2=36),"",IF(AND(A2>=1,A2<=35),0.1,"Count"))
change the commas to semicolons if your regional settings require.

[PaMart]

Well thank you for the extraordinarily fast response! But the cell I want to access is E3 and to be frank I'm not sure just where thr E3 should figure in the equation.
I wonder if you might be so kind as to include E3 so I can just input the formulae as it is

[Sam Capricci]

ok, this then... =IF(OR(E3="",E3=36),"",IF(AND(E3>=1,E3<=35),0.1,"Count"))

A1 and A2 are often used by many on this forum when we are not given the exact cell locations. I assumed (and apparently was wrong) that you knew to adjust the cell location to suit your needs.

[PaMart]

Mon Ami, what can I say other than thank you very much you are a star

[Sam Capricci]

you are welcome, AND thank you for the rep!