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

=IF(A1<"None",IF(A1=the_number,"Yes in A","No in
A"),IF(B1=the_number,"Yes in B","No in B"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Boulder257" wrote
in message ...

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