| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to set up an IF formula
formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is
(200) and C1 is (100) the result is still 100% but should be (100%). How can I set-up formula so it correctly recognizes both circumstances? As always thank YOU. -- Gene |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to set up an IF formula
Maybe
=(B1-C1)/MIN(B1,C1) Mike "Gene" wrote: formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is (200) and C1 is (100) the result is still 100% but should be (100%). How can I set-up formula so it correctly recognizes both circumstances? As always thank YOU. -- Gene |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to set up an IF formula
Gene wrote:
formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is (200) and C1 is (100) the result is still 100% but should be (100%). How can I set-up formula so it correctly recognizes both circumstances? As always thank YOU. Why would a negative number divided by a negative number not be positive? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to set up an IF formula
Good point, I missed the parenthesis and assumed all No's positive
"Glenn" wrote: Gene wrote: formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is (200) and C1 is (100) the result is still 100% but should be (100%). How can I set-up formula so it correctly recognizes both circumstances? As always thank YOU. Why would a negative number divided by a negative number not be positive? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to set up an IF formula
why would two netatives not be postive was the question? could be but in
this situation it isn't. In this circumstance (100) is the budget amount and (200) is the actual attained. Thus the result is (100%) under budget. So I'm trying to see if there is a method to reflect this while keeping the basic formula that usually has other positive or negative results. -- Gene "Glenn" wrote: Gene wrote: formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is (200) and C1 is (100) the result is still 100% but should be (100%). How can I set-up formula so it correctly recognizes both circumstances? As always thank YOU. Why would a negative number divided by a negative number not be positive? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to set up an IF formula
Gene wrote:
why would two netatives not be postive was the question? could be but in this situation it isn't. In this circumstance (100) is the budget amount and (200) is the actual attained. Thus the result is (100%) under budget. So I'm trying to see if there is a method to reflect this while keeping the basic formula that usually has other positive or negative results. Try this: =(B1-C1)/ABS(C1) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to set up an IF formula
Thank YOU Glenn!
-- Gene "Glenn" wrote: Gene wrote: why would two netatives not be postive was the question? could be but in this situation it isn't. In this circumstance (100) is the budget amount and (200) is the actual attained. Thus the result is (100%) under budget. So I'm trying to see if there is a method to reflect this while keeping the basic formula that usually has other positive or negative results. Try this: =(B1-C1)/ABS(C1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
