| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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+B22,"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!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Question
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" wrote: 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+B22,"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!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" wrote: Assuming poor rendition of your posted sample data. a2 is 500..........b2 is 600 =IF(A2+B22,"MEETING",IF(A2+B2<1,"NO MEETING")) returns MEETING a3 is 0.........b3 is 0 =IF(A3+B32,"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 wrote: 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+B22,"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!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" wrote: 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" wrote: 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+B22,"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!!!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Question
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" wrote: 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" wrote: 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" wrote: 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+B22,"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!!!! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Question
Clear your numbers and re-type them.
Any change? Gord On Tue, 2 Jun 2009 15:56:01 -0700, Rae''s Formula Question wrote: 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" wrote: Assuming poor rendition of your posted sample data. a2 is 500..........b2 is 600 =IF(A2+B22,"MEETING",IF(A2+B2<1,"NO MEETING")) returns MEETING a3 is 0.........b3 is 0 =IF(A3+B32,"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 wrote: 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+B22,"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!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Formula question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Worksheet Functions | |||
| formula question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Linear Mode
