Thread
:
Formula Question
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
Formula Question
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 With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben