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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Fluff

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

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,095,430
Messages
5,444,408
Members
405,280
Latest member
Galliganr0

This Week's Hot Topics

Top