Please amend this formula

lukerees83

Board Regular
Joined
Mar 28, 2011
Messages
59
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?
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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
Joined
Mar 28, 2011
Messages
59
That's great thanks. Just what I needed & makes it easier than using an IFERROR formula each time.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,868
Members
409,842
Latest member
mfernandezcean
Top