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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

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