help with a formulafor an excell newbie

[donnalcd]

Hi
I'm new to excel & teaching myself.
I have a simple expenses spread sheet where I have 2 columns but need to use which ever column total is higher in another cells sum.
example if column b total is higher than column a then I want to use column b total in my sum elsewhere in the sheet
any help much appreciacated

 

[AhoyNC]

Take a look at the MAX function,
Something like the example below:

Excel Workbook
	A	B	C	D
1	4	8		12
2				20
Sheet

 

[donnalcd]

Thanks for your reply but I'm not really understanding what the answer is sorry.
my example pic might help me explain better.
I want the cell quoting actual spend to be the result of column A if it is higher than B

Thanks again



[TABLE="width: 749"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]expected expense[/TD]
[TD]actual expense[/TD]
[TD][/TD]
[TD]amount to spend[/TD]
[TD]actual spend[/TD]
[TD]amount left[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]total[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]113[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[donnalcd]

sorry I meant B if its higher than A

 

[AhoyNC]

Like this?

Excel Workbook
	A	B	C	D	E	F	G
1		expected expense	actual expense		amount to spend	actual spend	amount left
2		10	10		200	113	90
3		12	13
4		21	22
5		67	68
6	total	110	113
Sheet

 

[donnalcd]

Oh Thank you so much, that worked a treat.

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.