| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEED HELP WITH EXCEL FORMULA
NEED HELP WITH THE FOLLOWING FORUMLA. i WANT TO TAKE THE SUM OF A1 MINUS A2
AND ADD 11 TO THE ANSWER. THIS ASSUMES THAT A1 IS GREATER THAN A2. IF HOWEVER A2 IS LARGER THAN A1, I WANT TO TAKE A2 MINUS A1 AND ADD 11 TO THE ANSWER. OBVIOUSLY THERE IS A VARIABLE THAT MUST BE LOOKED AT FIRST, IS A1 LARGER THAN A2, OR IS A2 LARGER THAN A1. CAN YOU GIVE ME THE CORRECT FORMULA TO ENTER TO SOLVE THAT VARIABLE? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED HELP WITH EXCEL FORMULA
Dan,
Turn the caps lock off, it makes things difficult to read and is considered to be shouting. In it's long form =(MAX(A1,A2)-MIN(A1,A2))+11 or =ABS(A1-A2)+11 Mike "Dan A." wrote: NEED HELP WITH THE FOLLOWING FORUMLA. i WANT TO TAKE THE SUM OF A1 MINUS A2 AND ADD 11 TO THE ANSWER. THIS ASSUMES THAT A1 IS GREATER THAN A2. IF HOWEVER A2 IS LARGER THAN A1, I WANT TO TAKE A2 MINUS A1 AND ADD 11 TO THE ANSWER. OBVIOUSLY THERE IS A VARIABLE THAT MUST BE LOOKED AT FIRST, IS A1 LARGER THAN A2, OR IS A2 LARGER THAN A1. CAN YOU GIVE ME THE CORRECT FORMULA TO ENTER TO SOLVE THAT VARIABLE? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED HELP WITH EXCEL FORMULA
Try
=MAX(A1:A2)-MIN(A1:A2)+11 PS: Please avoid upper case letters which is difficult to read/// If this post helps click Yes --------------- Jacob Skaria "Dan A." wrote: NEED HELP WITH THE FOLLOWING FORUMLA. i WANT TO TAKE THE SUM OF A1 MINUS A2 AND ADD 11 TO THE ANSWER. THIS ASSUMES THAT A1 IS GREATER THAN A2. IF HOWEVER A2 IS LARGER THAN A1, I WANT TO TAKE A2 MINUS A1 AND ADD 11 TO THE ANSWER. OBVIOUSLY THERE IS A VARIABLE THAT MUST BE LOOKED AT FIRST, IS A1 LARGER THAN A2, OR IS A2 LARGER THAN A1. CAN YOU GIVE ME THE CORRECT FORMULA TO ENTER TO SOLVE THAT VARIABLE? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED HELP WITH EXCEL FORMULA
Give this formula a try...
=ABS(A1-A2)+11 By the way... your Caps Lock key appears stuck... you should really get that fixed. -- Rick (MVP - Excel) "Dan A." wrote in message ... NEED HELP WITH THE FOLLOWING FORUMLA. i WANT TO TAKE THE SUM OF A1 MINUS A2 AND ADD 11 TO THE ANSWER. THIS ASSUMES THAT A1 IS GREATER THAN A2. IF HOWEVER A2 IS LARGER THAN A1, I WANT TO TAKE A2 MINUS A1 AND ADD 11 TO THE ANSWER. OBVIOUSLY THERE IS A VARIABLE THAT MUST BE LOOKED AT FIRST, IS A1 LARGER THAN A2, OR IS A2 LARGER THAN A1. CAN YOU GIVE ME THE CORRECT FORMULA TO ENTER TO SOLVE THAT VARIABLE? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Hybrid Mode
