Let's say I have the number of fruits I own in column A, and the number
of vegetables I own in column B. I want to create a formula in column C
that will first look at column A, if Column A says none, than it needs
to look at column B and decide if the cell is greater or less than a
determined number. Then, if Column A doesn't say "none" and instead has
a number, I need it to result based upon whether column A is greater or
less than a certain number.

Any ideas?


--
Boulder257
------------------------------------------------------------------------
Boulder257's Profile: http://www.excelforum.com/member.php...o&userid=20053
View this thread: http://www.excelforum.com/showthread...hreadid=559347