| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
I need to do the following.
Column A+C-E= Column B+D-F= Compare these formulas and if the answer is the same post the answer in column G,if < than 0, if not say false. How do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
In G1:
=IF(A1+C1-E1=B1+D1-F1,A1+C1-E1,"FALSE") Copy down as required. Hope this helps. Pete On Jan 28, 2:06*am, chrisnsmith wrote: I need to do the following. Column A+C-E= Column B+D-F= Compare these formulas and if the answer is the same post the answer in column G,if < than 0, if not say false. How do I do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
Thanks Pete, the formula does just what I wanted, but can you tell me how to
get it to return the number as a positive even if it is a negative? "Pete_UK" wrote: In G1: =IF(A1+C1-E1=B1+D1-F1,A1+C1-E1,"FALSE") Copy down as required. Hope this helps. Pete On Jan 28, 2:06 am, chrisnsmith wrote: I need to do the following. Column A+C-E= Column B+D-F= Compare these formulas and if the answer is the same post the answer in column G,if < than 0, if not say false. How do I do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
me how to get it to return the number as a positive
even if it is a negative? If there might be round-off errors, perhaps another idea... =IF(ABS(A1 - B1 + C1 - D1 - E1 + F1) < 1E-10,ABS(A1+C1-E1),FALSE) = = = HTH :) Dana DeLouis chrisnsmith wrote: Thanks Pete, the formula does just what I wanted, but can you tell me how to get it to return the number as a positive even if it is a negative? "Pete_UK" wrote: In G1: =IF(A1+C1-E1=B1+D1-F1,A1+C1-E1,"FALSE") Copy down as required. Hope this helps. Pete On Jan 28, 2:06 am, chrisnsmith wrote: I need to do the following. Column A+C-E= Column B+D-F= Compare these formulas and if the answer is the same post the answer in column G,if < than 0, if not say false. How do I do this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
How can I get this formula to recognize blank cells as 0 (zero)?
"Pete_UK" wrote: In G1: =IF(A1+C1-E1=B1+D1-F1,A1+C1-E1,"FALSE") Copy down as required. Hope this helps. Pete On Jan 28, 2:06 am, chrisnsmith wrote: I need to do the following. Column A+C-E= Column B+D-F= Compare these formulas and if the answer is the same post the answer in column G,if < than 0, if not say false. How do I do this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
That formula *will* treat blank cells as zero.
-- David Biddulph "chrisnsmith" wrote in message ... How can I get this formula to recognize blank cells as 0 (zero)? "Pete_UK" wrote: In G1: =IF(A1+C1-E1=B1+D1-F1,A1+C1-E1,"FALSE") Copy down as required. Hope this helps. Pete On Jan 28, 2:06 am, chrisnsmith wrote: I need to do the following. Column A+C-E= Column B+D-F= Compare these formulas and if the answer is the same post the answer in column G,if < than 0, if not say false. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
