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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com