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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Fluff

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

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,089,886
Messages
5,411,000
Members
403,336
Latest member
amreeves87

This Week's Hot Topics

Top