ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what are the formulas to minus from excel (https://www.excelbanter.com/excel-discussion-misc-queries/43981-what-formulas-minus-excel.html)

MARIA

what are the formulas to minus from excel
 
I'M TRYING TO BALANCE MY CHECK BOOK ON EXCEL AND I FORGOT HOW TO MINUS. CAN
ANYONE PLEASE TELL ME THE FORMULAS

THANK YOU,

R.VENKATARAMAN

lastbalance-withdrawal+deposit


"MARIA" wrote in message
...
I'M TRYING TO BALANCE MY CHECK BOOK ON EXCEL AND I FORGOT HOW TO MINUS.

CAN
ANYONE PLEASE TELL ME THE FORMULAS

THANK YOU,




Jon Quixley


Maria,

=A2-b2

will subtract the value in cell A2 from B2

Is this what you're after, or is it something more complexed

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=402061


garfield-n-odie

Are you sure about that, Jon?

Jon Quixley wrote:
Maria,

=A2-b2

will subtract the value in cell A2 from B2

Is this what you're after, or is it something more complexed

Jon




NlCO


You can always do it the difficult way, if you want to rest A1 with A2
you can put:

=if(A1<0,(A1^2)^(1/2)*522/(261*2)*(-1)-(A2*-(sqrt(65478)^2)+32739*2+1),A1-35486*(sqrt(16)-4)-A2)

Any comments?? :)

Saludos

NlCO


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=402061



All times are GMT +1. The time now is 10:08 PM.

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