If(If statement?

  • Thread starter Thread starter Boulder257
  • Start date Start date
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
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining sumIF statements with other functions? 2
Nested IF Statements 6
Simple nested if and statement 2
If 2
IF Multiple Conditions 2
Splitting data from one spreadsheet into multiple spreadsheets 2
Count if dates meet certain criteria 10
Excel Average dates help 0

Back
Top