Please amend this formula

[lukerees83]

This is the formula I currently have in one of my cells, and I have dragged it down one column so it calculates for hundreds more:

=IFERROR(((F5*60)+G5)-25,"")

However, if this formula is applied to 2 cells which are blank (for example in this case F5 & G5), it will of course keep coming up with -25 as the result.

I would like to add a little extra to this formula so that it says "if the result of this calculation is -25 just leave the cell blank."

Is this possible?

 

[barry houdini]

You could try counting the values in F5 and G5 and only calculate if both are populated, e.g.

=IF(COUNT(F5,G5)=2,F5*60+G5-25,"")

 

[lukerees83]

That's great thanks. Just what I needed & makes it easier than using an IFERROR formula each time.