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!!!! |
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) |