#### lukerees83

##### Board Regular
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?

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### barry houdini

##### MrExcel MVP
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

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

Replies
3
Views
78
Replies
5
Views
125
Replies
16
Views
143
Replies
4
Views
53
Replies
3
Views
154