Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF FORMULA HELP
I have been trying to create an IF statement that gives a percentage as the
answer. I need the percentage of change of A compared to B -I can create the statement if column A is Positive and Column B is Positive or if A is negative and B is positive but I can not get the statement to work if A is positive and B is negative. this is the formula I am using IF(B1<0,+A1/-B1,A1/B1) I have just not been able to add the next formula to make this work. Can any one help? thanks for the help enjoy your day gail |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF FORMULA HELP
Try:
=IF(B1=0,0,ABS(A1/B1)) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Gail" wrote in message ... I have been trying to create an IF statement that gives a percentage as the answer. I need the percentage of change of A compared to B -I can create the statement if column A is Positive and Column B is Positive or if A is negative and B is positive but I can not get the statement to work if A is positive and B is negative. this is the formula I am using IF(B1<0,+A1/-B1,A1/B1) I have just not been able to add the next formula to make this work. Can any one help? thanks for the help enjoy your day gail |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF FORMULA HELP
Maybe one of these....?
=IF(N(B1),A1/ABS(B1),"INVALID") OR =A1/ABS(B1) Does that help? *********** Regards, Ron XL2002, WinXP "Gail" wrote: I have been trying to create an IF statement that gives a percentage as the answer. I need the percentage of change of A compared to B -I can create the statement if column A is Positive and Column B is Positive or if A is negative and B is positive but I can not get the statement to work if A is positive and B is negative. this is the formula I am using IF(B1<0,+A1/-B1,A1/B1) I have just not been able to add the next formula to make this work. Can any one help? thanks for the help enjoy your day gail |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF FORMULA HELP
Maybe I missed something, but it seems to me that the formula to figure out
the percentage change from column A to column be would ALWAYS be B1/A1...wouldn't it? If A is 8 and B is 10, B/A = 125% (8 x 125% = 10)... If A is -8 and B is 5, B/A = -63% (-8 x -63% = 5)... If A is 8 and B is -9, B/A = -113% (8 x -113% = -9)... Given those three scenarios, what actual result were you looking for? The only other formula that I could come up with was still not an if statement, but instead =(B1-A1)/A1 which results in the change BETWEEN the numbers. -- KimCo Please post all replies to the newsgroup |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF FORMULA HELP
I can make my formula work to get the percentages,But I can not get it to
work if A is positive and B is negative with the percentage given as a percent of positive increase. ie column a 29 column b -1900 my formula gives a 15% improvement instead of 115%. So what I need is a formula that will give me negative to positive with a positive percentage, and a within this formula negative to negative and positive to negative. thanks for the help enjoy your day gail "Gail" wrote: I have been trying to create an IF statement that gives a percentage as the answer. I need the percentage of change of A compared to B -I can create the statement if column A is Positive and Column B is Positive or if A is negative and B is positive but I can not get the statement to work if A is positive and B is negative. this is the formula I am using IF(B1<0,+A1/-B1,A1/B1) I have just not been able to add the next formula to make this work. Can any one help? thanks for the help enjoy your day gail |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|