| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help - subtracting numbers in two colums but using a specific number if one column is greater than another
You don't need the SUM function.
You have changed your parameters from your original posting. "subtracts w2 from x2" was your original. Here you are subtracting X2 from W2 You do not need CSE See my earlier reply. Gord On Mon, 4 Jan 2010 14:26:06 -0800 (PST), Michelle wrote: I THINK I JUST FIGURED IT OUT!! THE FORMULA I ARRIVED AT IS =IF(X2W2, W2,SUM(W2,-X2)) DOES THIS SEEM CORRECT? I USED CSE WHEN I ENTERED THE FORMULA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT | Excel Worksheet Functions | |||
| Find min() value greater than zero in column of numbers | New Users to Excel | |||
| Adding or subtracting numbers from a column | Excel Discussion (Misc queries) | |||
| How to average a column of numbers that are greater than 0? | Excel Worksheet Functions | |||
| formula of two numbers if greater than 500 | Excel Discussion (Misc queries) | |||
Threaded Mode
