M
M John
I'm running out of ideas for the following situation:
If Cell.Value >0 and Cell.Value <=0.2 then
(code)
Else If Cell.Value >0.2 and Cell.Value <=.4
(other code)
Else If Cell.Value >0.4 and Cell.Value <=.6
(other code)
Else If Cell.Value >0.6 and Cell.Value <=.8
(other code)
Else Cell.Value >0.8 and Cell.Value <=1
(other code)
End If
Is there an easier way to do this? Am I missing something obvious? Right
now, I can't figure out how to make this scheme work.
Any pointers you can give me will be gratefully received.
Thanks,
MJohn
If Cell.Value >0 and Cell.Value <=0.2 then
(code)
Else If Cell.Value >0.2 and Cell.Value <=.4
(other code)
Else If Cell.Value >0.4 and Cell.Value <=.6
(other code)
Else If Cell.Value >0.6 and Cell.Value <=.8
(other code)
Else Cell.Value >0.8 and Cell.Value <=1
(other code)
End If
Is there an easier way to do this? Am I missing something obvious? Right
now, I can't figure out how to make this scheme work.
Any pointers you can give me will be gratefully received.
Thanks,
MJohn