Excel 2013 - IF statement with partial text

[MBrinMO]

Hi,

I have a spreadsheet that we are using for auditing an account that is approximately 7500 lines long.
The spreadsheet has a subtotal line between each account ... and this is where I would like to compare amounts.

A B C D
SMITH Total 97.65 144.90 ________

So if Column A has the word "Total" , then C - B = D

It's the partial word that is throwing me. I've tried @if(A="*Total",C-B,""). That doesn't give me a result.

Thanks !

 

[Jonmo1]

Welcome to the board.

Try
=IF(ISNUMBER(SEARCH("Total",A)),C-B,"")

 

[MBrinMO]

Yes! Thanks!

I don't understand it, but will be able to read up and dissect it later.

Many thanks for a speedy reply. You have saved me a couple hours of manually comparing.

 

[Jonmo1]

Glad to help, thanks for the feedback.