| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF & AND in formula
Hi.
I'm using Excel 2000, in simple terms, I need a formula for the following. I'm working with numbers. IF A2 is GREATER than B2, then A2+B2 OR IF A2 is LESS than B2, then B2-A2 Thanks, Latsh NJ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using IF & AND in formula
here it is..
=IF(A2B2,A2+B2,IF(A2<B2,B2-A2)) Joe Latsh wrote: Hi. I'm using Excel 2000, in simple terms, I need a formula for the following. I'm working with numbers. IF A2 is GREATER than B2, then A2+B2 OR IF A2 is LESS than B2, then B2-A2 Thanks, Latsh NJ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using IF & AND in formula
=If(A2B2,A2+B2,B2-A2) Latsh wrote: Hi. I'm using Excel 2000, in simple terms, I need a formula for the following. I'm working with numbers. IF A2 is GREATER than B2, then A2+B2 OR IF A2 is LESS than B2, then B2-A2 Thanks, Latsh NJ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using IF & AND in formula
What happens if A2=B2?
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Latsh" wrote in message ... Hi. I'm using Excel 2000, in simple terms, I need a formula for the following. I'm working with numbers. IF A2 is GREATER than B2, then A2+B2 OR IF A2 is LESS than B2, then B2-A2 Thanks, Latsh NJ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using IF & AND in formula
Mark:
he wants B2-A2 not when A2=B2.. Mark K. wrote: =If(A2B2,A2+B2,B2-A2) Latsh wrote: Hi. I'm using Excel 2000, in simple terms, I need a formula for the following. I'm working with numbers. IF A2 is GREATER than B2, then A2+B2 OR IF A2 is LESS than B2, then B2-A2 Thanks, Latsh NJ |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using IF & AND in formula
Perhaps
=B2+SIGN(A2-B2)*A2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
