ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   functions (https://www.excelbanter.com/excel-discussion-misc-queries/167263-functions.html)

mahmoud

functions
 
a=constant suppose 600000
b is reciept
c is the balance


Bernard Liengme

functions
 
And the question is?
Maybe the answer could be:
A1 =600000, B1=100000 (money received) and C1 =A1-B1 (balance of 50000)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mahmoud" wrote in message
...
a=constant suppose 600000
b is reciept
c is the balance




David Biddulph[_2_]

functions
 
If you are asking how to add A1 and B1, the formula is =A1+B1.
--
David Biddulph

"mahmoud" wrote in message
...
a=constant suppose 600000
b is reciept
c is the balance




Stan Brown

functions
 
Sun, 25 Nov 2007 05:30:01 -0800 from mahmoud
:
a=constant suppose 600000
b is reciept
c is the balance


And what is your question about functions?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

mahmoud

functions
 


"Bernard Liengme" wrote:

And the question is?
Maybe the answer could be:
A1 =600000, B1=100000 (money received) and C1 =A1-B1 (balance of 50000)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mahmoud" wrote in message
...
a=constant suppose 600000
b is reciept
c is the balance

suppose in coloumn a there is a1 value 60000

coloumn b represent parametric value b1=100,b2=200.....etc
and c represent the balnce always



pinmaster

functions
 
Hi,

Not sure if this will help but try this in C1:

=IF(B1="","",$A$1-SUM($B$1:B1))
copy down as far as needed

Regards!
Jean-Guy

"mahmoud" wrote:

a=constant suppose 600000
b is reciept
c is the balance



All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com