results between two cells

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,091
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?
 

Fluff

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

Fluff

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

Forum statistics

Threads
1,078,216
Messages
5,338,907
Members
399,267
Latest member
Danielle1017

Some videos you may like

This Week's Hot Topics

Top