If(If statement?

B

Boulder257

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

Any ideas
 
B

Bob Phillips

=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)
 
Top