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

	expected expense	actual expense		amount to spend	actual spend	amount left
	10	10		200	110	90
	12	13
	21	22
	67	68
total	110	113

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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.