quick excel help

[excelhelpmee]

Hi

Hopefully a simple one to help me with.

I am doing a simple spreadsheet for inheritance tax calculation, basically if the threshold amount in D70 is more than the estate value in D69, I want the above threshold (D71) to show 0. If the threshold amount in D70 is less than then estate value in D69 I want it to actually calculate the amount its above the threshold so the tax calculation also works.

Thanks in advance!

[63falcondude]

Hello and welcome to the forum.

Try this in D71:

=IF(D70>D69,0,D69-D70)

or this:

=MAX(0,D69-D70)

[excelhelpmee]

Amazing! thank you. It was doing my nut in, i had the first bit but couldnt work out the second bit, now i look at it how did i miss that!

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and next time use a thread title to something that better explains your problem. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.