Formula Needed - Monthly Budget

[Ranger32195]

Good Afternoon,

I am looking for a formula to sort out a budget problem I am currently working on... I am guessing that the formula is pretty simple but my mind is blank...

What I am trying to do is:

Cell A1 is my cash budget
Cell A3 is actual cash used
Cell A5 is The Difference between A1 & A3 (sum A1-A3)

What I want in Cell A7 is a formula to tell me if my Budget is over 50% either way..

For instance if A1 = 100 and A3 = 155 then I am 55% over and would like a note to appear saying "Explanation required".
If A1 = 100 and A3 = 45 then I am 55% under my Budget and would like a note to appear saying "Explanation required".

Hopefully someone can help me

 

[Sanjeev1976]

Please use the below mentioned formula :

=IF(OR(C3/A3>50%,C3/A3<-50%),"Explanation Required","")

Sanjeev

 

[Ranger32195]

Could you tell me what C3 is the value of? Is it A1 ?

Thanks for your reply

 

[texasalynn]

try this

Excel Workbook
	A	B	C
1	Cash Budget	100	75
2
3	Actual Cash	125	165
4
5	Difference	25	90
6
7	50%+/- Of Budget	On Track	Explanation required
Sheet2

 

[DrSynthetic]

What I am trying to do is:

Cell A1 is my cash budget
Cell A3 is actual cash used
Cell A5 is The Difference between A1 & A3 (sum A1-A3)

What I want in Cell A7 is a formula to tell me if my Budget is over 50% either way..

For instance if A1 = 100 and A3 = 155 then I am 55% over and would like a note to appear saying "Explanation required".
If A1 = 100 and A3 = 45 then I am 55% under my Budget and would like a note to appear saying "Explanation required".>>>>

In cell A7, the following formula should work. =If(A3>A1*1.50,"Explanation needed Over Budget","OK") -


Your formula for under would be =If(A3<A1*.50,"Explanation needed Under Budget",<A1*.50,"EXPLANATION p Under required Budget)<> "OK")
I seperated each so you could see the principle behind each. You could put one formula in A7 and the other in A8

The formula below combines both elements and can be in A7 using the IF and also the OR statement.

Here is your formula

=IF(OR(A3<A1*0.5, A3>A1*1.5), "Explanation Needed","OK")

 

[Sanjeev1976]

Please use this instead of previous one

=IF(OR(A5/A1>50%,A5/A1<-50%),"Explanation Required","")

Sanjeev

 

[DrSynthetic]

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 122px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right">15000</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: right">1000</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 25px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>Explanation Needed</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A7</TD><TD>=IF(OR(A3<A1*0.5, A3>A1*1.5), "Explanation Needed","OK")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Here is my formula using this program and it displays correctly finally

 

[WERNER SLABBERT]

Good Afternoon,

I am looking for a formula to sort out a budget problem I am currently working on... I am guessing that the formula is pretty simple but my mind is blank...

What I am trying to do is:

Cell A1 is my cash budget
Cell A3 is actual cash used
Cell A5 is The Difference between A1 & A3 (sum A1-A3)

What I want in Cell A7 is a formula to tell me if my Budget is over 50% either way..

For instance if A1 = 100 and A3 = 155 then I am 55% over and would like a note to appear saying "Explanation required".
If A1 = 100 and A3 = 45 then I am 55% under my Budget and would like a note to appear saying "Explanation required".

Hopefully someone can help me

=IF(OR(A5/A1>=50%,A5/A1<=-50%),"Explanation Required","")
SAME AS THE OTHER FORMULA THE MESSAGE WILL JUST POP UP FROM 50% ON THE OTHERS WILL ONLY COME UP FROM 51% ONWARDS

 

[WERNER SLABBERT]

=if(or(a3/a1>=50%,a3/a1<=-50%),"explanation required","OK")

same as the other formula the message will just pop up from 50% on the others will only come up from 51% onwards

also add this formula into cell a6 to calculate the diff between in percent

=(a3-a1)/abs(a1)

hope it helps

 

[DrSynthetic]

My formula keeps displaying wrong - for some reason it wont show when I try to use the less than signs in the statement. Basically it is the same as the others only it used the math of multiplying the budget by either .50 or 1.50 instead of using a %. two different paths to the same answer.