logical function

[ivy]

I have this kind of formula if I did not put any amount in that column is it
possible just to reflect 0 instead of A3?

=IF(OR($S4>=500000,$T4>=500000,$U4>=500000,$V4>=500000,$W4>=500000,$X4>=500000),"A1",IF(OR($S4>=20000,$T4>=20000,$U4>=20000,$V4>=20000,$W4>=20000,$X4>=20000),"A2",IF(OR($S4<=0,$T4<=20000,$U4>=500000,$V4<=20000,$W4<=20000,$X4<=20000),"A3"," ")))


Thanks.

 

[Arvin Meyer [MVP]]

You may want to ask this in an Excel newsgroup which will be more
appropriate to your problem. This newsgroup is dedicated to the Microsoft
Access database product. The Microsoft website may have misdirected you.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com