IF function to get the difference in two cells as answer, if criteria met

[TAKY]

Hello Guyz!

I am new to this form and to Excel as well.

I am making a trial balance and i want an IF formula that should be

=IF(H26<E26,"E26-H26","") but instead of E26-H26 i want the cell to show the difference in numbers but it shows E26-H26.

For instance if E26=100 and H26=60 , i want it to show the answer as 40 not "E26-H26".

Please help me in this regard, Any help will be very appreciated.

[FDibbins]

Hi, welcome to the forum

=IF(H26<E26,"E26-H26","") but instead of E26-H26 i want the cell to show the difference in numbers but it shows E26-H26.

That is because you have the formula wrapped inside ""...this is turning it into text. Try this instead...
=IF(H26<E26,E26-H26,"")

[TAKY]

Thank You FDibbins !

It worked perfectly. I have been trying to do it for 2 hrs.

Thanks once again.

[FDibbins]

Happy to help, gotta watch those ""

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

[TAKY]

Done...Both of them.

Thank you...

It was very helpful of you.

[FDibbins]

Thank you