| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Budget functon
In a budget I set up, I need one column to calculate if the amount paid is
over the budget amount and another column if it is under the column amount. I can't figure out how to enter a formula that works in Excel 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Budget functon
If your budget amount is in A1 and your actual amount is in B1, C1 could be:
=IF(B1A1,B1-A1,"") and D1 could be: =IF(B1<A1,B1-A1,"") HTH Jim "bankercrystal" wrote: In a budget I set up, I need one column to calculate if the amount paid is over the budget amount and another column if it is under the column amount. I can't figure out how to enter a formula that works in Excel 2003. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Budget functon
I put the formula in and the cell is only showing the formula and not showing
the result. I;m not sure what I did wrong. Also, how do I make the formula go into each cell in a column without changing it in each cell? "Jim" wrote: If your budget amount is in A1 and your actual amount is in B1, C1 could be: =IF(B1A1,B1-A1,"") and D1 could be: =IF(B1<A1,B1-A1,"") HTH Jim "bankercrystal" wrote: In a budget I set up, I need one column to calculate if the amount paid is over the budget amount and another column if it is under the column amount. I can't figure out how to enter a formula that works in Excel 2003. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Budget functon
If it is showing the formula rather than the result, it sounds as if you've
got the cell formatted as text. Format as General and re-enter the formula. To fill down the column, double-click the square fill handle at the bottom right-hand corner of the cell. [Otherwise drag the fill handle down the column, or copy the cell, select the rest of the column and paste.] -- David Biddulph "bankercrystal" wrote in message ... I put the formula in and the cell is only showing the formula and not showing the result. I;m not sure what I did wrong. Also, how do I make the formula go into each cell in a column without changing it in each cell? "Jim" wrote: If your budget amount is in A1 and your actual amount is in B1, C1 could be: =IF(B1A1,B1-A1,"") and D1 could be: =IF(B1<A1,B1-A1,"") HTH Jim "bankercrystal" wrote: In a budget I set up, I need one column to calculate if the amount paid is over the budget amount and another column if it is under the column amount. I can't figure out how to enter a formula that works in Excel 2003. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Budget functon
So close, the one column of my budget now shows the correct #'s, the other
column only shows the formula. I have general in for the cell. I'm not sure what to do now. I have re-entered the info etc....nothing. "David Biddulph" wrote: If it is showing the formula rather than the result, it sounds as if you've got the cell formatted as text. Format as General and re-enter the formula. To fill down the column, double-click the square fill handle at the bottom right-hand corner of the cell. [Otherwise drag the fill handle down the column, or copy the cell, select the rest of the column and paste.] -- David Biddulph "bankercrystal" wrote in message ... I put the formula in and the cell is only showing the formula and not showing the result. I;m not sure what I did wrong. Also, how do I make the formula go into each cell in a column without changing it in each cell? "Jim" wrote: If your budget amount is in A1 and your actual amount is in B1, C1 could be: =IF(B1A1,B1-A1,"") and D1 could be: =IF(B1<A1,B1-A1,"") HTH Jim "bankercrystal" wrote: In a budget I set up, I need one column to calculate if the amount paid is over the budget amount and another column if it is under the column amount. I can't figure out how to enter a formula that works in Excel 2003. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Budget functon
Format as General
Re-enter the formula. -- David Biddulph "bankercrystal" wrote in message ... So close, the one column of my budget now shows the correct #'s, the other column only shows the formula. I have general in for the cell. I'm not sure what to do now. I have re-entered the info etc....nothing. "David Biddulph" wrote: If it is showing the formula rather than the result, it sounds as if you've got the cell formatted as text. Format as General and re-enter the formula. To fill down the column, double-click the square fill handle at the bottom right-hand corner of the cell. [Otherwise drag the fill handle down the column, or copy the cell, select the rest of the column and paste.] -- David Biddulph "bankercrystal" wrote in message ... I put the formula in and the cell is only showing the formula and not showing the result. I;m not sure what I did wrong. Also, how do I make the formula go into each cell in a column without changing it in each cell? "Jim" wrote: If your budget amount is in A1 and your actual amount is in B1, C1 could be: =IF(B1A1,B1-A1,"") and D1 could be: =IF(B1<A1,B1-A1,"") HTH Jim "bankercrystal" wrote: In a budget I set up, I need one column to calculate if the amount paid is over the budget amount and another column if it is under the column amount. I can't figure out how to enter a formula that works in Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding numbers of a functon | Excel Worksheet Functions | |||
| How to set the default color for fill in functon? | Excel Discussion (Misc queries) | |||
| How to set the default color for fill in functon? | Setting up and Configuration of Excel | |||
| Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions | |||
| custom worksheet functon is changed to lowercase | Excel Worksheet Functions | |||
Linear Mode
