Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Hi,
Would anyone know what the formula should be for this below =sum(a1+a2)/abs(a1) If I want to use a conditional statement If a1=0 need the result to be 100%, but if A1 is any number other than 0 I need the formula above to work as it should. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Try this...
=IF(A1=0,100,SUM(A1+A2)/ABS(A1)) I'm not sure if the 100 should be 100% or 1... it depends on how you are making the cell show the percentage. Rick "Vic Abrahamian" wrote in message ... Hi, Would anyone know what the formula should be for this below =sum(a1+a2)/abs(a1) If I want to use a conditional statement If a1=0 need the result to be 100%, but if A1 is any number other than 0 I need the formula above to work as it should. Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Shouldn't there be a If Not statement too? what if A1 changes to a different
number? Thank you "Rick Rothstein (MVP - VB)" wrote: Try this... =IF(A1=0,100,SUM(A1+A2)/ABS(A1)) I'm not sure if the 100 should be 100% or 1... it depends on how you are making the cell show the percentage. Rick "Vic Abrahamian" wrote in message ... Hi, Would anyone know what the formula should be for this below =sum(a1+a2)/abs(a1) If I want to use a conditional statement If a1=0 need the result to be 100%, but if A1 is any number other than 0 I need the formula above to work as it should. Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
I'm not sure I'm following your question... the IF function I gave you
handles both the True and the False condition. It will return 100 if A1 = 0, otherwise (for any other value in A1) it will return whatever SUM(A1+A2)/ABS(A1) evaluates to. Isn't that what you asked for? Rick "Vic Abrahamian" wrote in message ... Shouldn't there be a If Not statement too? what if A1 changes to a different number? Thank you "Rick Rothstein (MVP - VB)" wrote: Try this... =IF(A1=0,100,SUM(A1+A2)/ABS(A1)) I'm not sure if the 100 should be 100% or 1... it depends on how you are making the cell show the percentage. Rick "Vic Abrahamian" wrote in message ... Hi, Would anyone know what the formula should be for this below =sum(a1+a2)/abs(a1) If I want to use a conditional statement If a1=0 need the result to be 100%, but if A1 is any number other than 0 I need the formula above to work as it should. Thank you |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Hi, I'm sorry.
Here is in an example A1=0 B1=9600 C1=sum(A1-b1) which equals (-9600) With the formula =(IF(A1=0,100,SUM(A1+B1)/ABS(A1))), I get 100 If I change the number to 2 I get 4801, is that correct? If I change the number to -2 I get 4799 "Rick Rothstein (MVP - VB)" wrote: I'm not sure I'm following your question... the IF function I gave you handles both the True and the False condition. It will return 100 if A1 = 0, otherwise (for any other value in A1) it will return whatever SUM(A1+A2)/ABS(A1) evaluates to. Isn't that what you asked for? Rick "Vic Abrahamian" wrote in message ... Shouldn't there be a If Not statement too? what if A1 changes to a different number? Thank you "Rick Rothstein (MVP - VB)" wrote: Try this... =IF(A1=0,100,SUM(A1+A2)/ABS(A1)) I'm not sure if the 100 should be 100% or 1... it depends on how you are making the cell show the percentage. Rick "Vic Abrahamian" wrote in message ... Hi, Would anyone know what the formula should be for this below =sum(a1+a2)/abs(a1) If I want to use a conditional statement If a1=0 need the result to be 100%, but if A1 is any number other than 0 I need the formula above to work as it should. Thank you |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula
Well, I don't know if that is correct or not... it is **your** formula (the
SUM divided by the ABS part), not mine. Also, you gave SUM(A1+A2) in your first post, but you are showing SUM(A1-B1) in your example (I'm more concerned with the switch from plus to minus than in the cell reference change), so I'm not sure what formula you really want. Also, I should have noted in my first response that you do not need the SUM function call at all... SUM(A1+B1) is the same as (A1+B1) and SUM(A1-B1) is the same as (A1-B1) Rick "Vic Abrahamian" wrote in message ... Hi, I'm sorry. Here is in an example A1=0 B1=9600 C1=sum(A1-b1) which equals (-9600) With the formula =(IF(A1=0,100,SUM(A1+B1)/ABS(A1))), I get 100 If I change the number to 2 I get 4801, is that correct? If I change the number to -2 I get 4799 "Rick Rothstein (MVP - VB)" wrote: I'm not sure I'm following your question... the IF function I gave you handles both the True and the False condition. It will return 100 if A1 = 0, otherwise (for any other value in A1) it will return whatever SUM(A1+A2)/ABS(A1) evaluates to. Isn't that what you asked for? Rick "Vic Abrahamian" wrote in message ... Shouldn't there be a If Not statement too? what if A1 changes to a different number? Thank you "Rick Rothstein (MVP - VB)" wrote: Try this... =IF(A1=0,100,SUM(A1+A2)/ABS(A1)) I'm not sure if the 100 should be 100% or 1... it depends on how you are making the cell show the percentage. Rick "Vic Abrahamian" wrote in message ... Hi, Would anyone know what the formula should be for this below =sum(a1+a2)/abs(a1) If I want to use a conditional statement If a1=0 need the result to be 100%, but if A1 is any number other than 0 I need the formula above to work as it should. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |