Formula Question

  • Thread starter Rae's Formula Question
  • Start date
R

Rae's Formula Question

Hi! I need some assistance with this formula ... can't seem to figure out
what I am doing wrong. Okay, here is my scenario:

Volume A Volume B Result
500 600 MEETING
0 0 MEETING

I need a formula that will do the following:

1. Add columns A and B together
2. If the sum of the two columns is greater than 2, then the column titled
Result would show the word "meeting"
3. If the sum of the two columns [A+B] is 1 or less, then the column titled
Result would show the word "no meeting"

Here is the formula I am using:

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING"))

Anyway, the formula I am using is not working as I need it to. Can anyone
help me out here? I am desperate!

Thank you!!!!
 
G

Gord Dibben

Assuming poor rendition of your posted sample data.

a2 is 500..........b2 is 600

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING")) returns MEETING

a3 is 0.........b3 is 0

=IF(A3+B3>2,"MEETING",IF(A3+B3<1,"NO MEETING")) returns NO MEETING

What is "not working" for you?


Gord Dibben MS Excel MVP


On Tue, 2 Jun 2009 15:10:01 -0700, Rae's Formula Question <Rae's Formula
 
C

CLGonline

your formula works with the exception of when the volumes equals between 1
and 2, what do you want to happen when volume equals between 1 and 2?
 
R

Rae''s Formula Question

Thanks for the note back. The issue I am having is the response is simply
MEETING. The formula is not working in that it searches out the parameters
of >2 or <1. Either way I can only get the formula to use MEETING. My
formula isn't being read by the cell and does not take into consideration the
NO MEETING. Do you have any suggestions for me on how to fix it so the
document reads and determines the MEETING or NO MEETING reference based upon
the numbers?

Gord Dibben said:
Assuming poor rendition of your posted sample data.

a2 is 500..........b2 is 600

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING")) returns MEETING

a3 is 0.........b3 is 0

=IF(A3+B3>2,"MEETING",IF(A3+B3<1,"NO MEETING")) returns NO MEETING

What is "not working" for you?


Gord Dibben MS Excel MVP


On Tue, 2 Jun 2009 15:10:01 -0700, Rae's Formula Question <Rae's Formula
Hi! I need some assistance with this formula ... can't seem to figure out
what I am doing wrong. Okay, here is my scenario:

Volume A Volume B Result
500 600 MEETING
0 0 MEETING

I need a formula that will do the following:

1. Add columns A and B together
2. If the sum of the two columns is greater than 2, then the column titled
Result would show the word "meeting"
3. If the sum of the two columns [A+B] is 1 or less, then the column titled
Result would show the word "no meeting"

Here is the formula I am using:

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING"))

Anyway, the formula I am using is not working as I need it to. Can anyone
help me out here? I am desperate!

Thank you!!!!
Click to expand...
Click to expand...
 
R

Rae''s Formula Question

Dear CLGonline

Thanks for the note ... but this is my issue, I cannot get the formula to
work. The only response is MEETING. The option of NO MEETING never comes
up. I have played with the >1 and/or <1 and then moved to the >2 and <1 ...
but neither way works and I only can get the cell to respond with MEETING.
There must be something wrong with my formula because I simply cannot get
this to work. Do you have any suggestions?

CLGonline said:
your formula works with the exception of when the volumes equals between 1
and 2, what do you want to happen when volume equals between 1 and 2?

Rae's Formula Question said:
Hi! I need some assistance with this formula ... can't seem to figure out
what I am doing wrong. Okay, here is my scenario:

Volume A Volume B Result
500 600 MEETING
0 0 MEETING

I need a formula that will do the following:

1. Add columns A and B together
2. If the sum of the two columns is greater than 2, then the column titled
Result would show the word "meeting"
3. If the sum of the two columns [A+B] is 1 or less, then the column titled
Result would show the word "no meeting"

Here is the formula I am using:

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING"))

Anyway, the formula I am using is not working as I need it to. Can anyone
help me out here? I am desperate!

Thank you!!!!
Click to expand...
Click to expand...
 
C

CLGonline

I copied the equation into excel and came up with the meeting and no meeting
results as designed from your equation.

Rae''s Formula Question said:
Dear CLGonline

Thanks for the note ... but this is my issue, I cannot get the formula to
work. The only response is MEETING. The option of NO MEETING never comes
up. I have played with the >1 and/or <1 and then moved to the >2 and <1 ...
but neither way works and I only can get the cell to respond with MEETING.
There must be something wrong with my formula because I simply cannot get
this to work. Do you have any suggestions?

CLGonline said:
your formula works with the exception of when the volumes equals between 1
and 2, what do you want to happen when volume equals between 1 and 2?

Rae's Formula Question said:
Hi! I need some assistance with this formula ... can't seem to figure out
what I am doing wrong. Okay, here is my scenario:

Volume A Volume B Result
500 600 MEETING
0 0 MEETING

I need a formula that will do the following:

1. Add columns A and B together
2. If the sum of the two columns is greater than 2, then the column titled
Result would show the word "meeting"
3. If the sum of the two columns [A+B] is 1 or less, then the column titled
Result would show the word "no meeting"

Here is the formula I am using:

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING"))

Anyway, the formula I am using is not working as I need it to. Can anyone
help me out here? I am desperate!

Thank you!!!!
Click to expand...
Click to expand...
Click to expand...
 
G

Gord Dibben

Clear your numbers and re-type them.

Any change?


Gord

Thanks for the note back. The issue I am having is the response is simply
MEETING. The formula is not working in that it searches out the parameters
of >2 or <1. Either way I can only get the formula to use MEETING. My
formula isn't being read by the cell and does not take into consideration the
NO MEETING. Do you have any suggestions for me on how to fix it so the
document reads and determines the MEETING or NO MEETING reference based upon
the numbers?

Gord Dibben said:
Assuming poor rendition of your posted sample data.

a2 is 500..........b2 is 600

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING")) returns MEETING

a3 is 0.........b3 is 0

=IF(A3+B3>2,"MEETING",IF(A3+B3<1,"NO MEETING")) returns NO MEETING

What is "not working" for you?


Gord Dibben MS Excel MVP


On Tue, 2 Jun 2009 15:10:01 -0700, Rae's Formula Question <Rae's Formula
Hi! I need some assistance with this formula ... can't seem to figure out
what I am doing wrong. Okay, here is my scenario:

Volume A Volume B Result
500 600 MEETING
0 0 MEETING

I need a formula that will do the following:

1. Add columns A and B together
2. If the sum of the two columns is greater than 2, then the column titled
Result would show the word "meeting"
3. If the sum of the two columns [A+B] is 1 or less, then the column titled
Result would show the word "no meeting"

Here is the formula I am using:

=IF(A2+B2>2,"MEETING",IF(A2+B2<1,"NO MEETING"))

Anyway, the formula I am using is not working as I need it to. Can anyone
help me out here? I am desperate!

Thank you!!!!
Click to expand...
Click to expand...
Click to expand...
 

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

What formula do I use to show the last cell with text in a colum 3
Copying formulas across columns 2
sum product if 2
Average with Conditions 1
Counting for multiple situations 3
formula for days between completed meetings 4
SumProd from 2 columns and date range 6
Count if statement 3

Top