results between two cells

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,107
Code:
=IFERROR(O7-O6,"")
Hello how can I avoid to see the result if there is no value in the cell of O7?
The formula should give me result if there is number in the cell O7, is it possible?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,785
Office Version
365
Platform
Windows
How about
=IF(O7="","",O7-O6)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,785
Office Version
365
Platform
Windows
My pleasure
 

Watch MrExcel Video

Forum statistics

Threads
1,095,779
Messages
5,446,460
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top