Easy excel formula

tmmellor1981

Board Regular
Joined
Jan 18, 2009
Messages
122
Afternoon all

one of those days to day , i have the following formula

=IF(ISERROR((SUM(F2-E2))),"",(SUM(F2-E2)))

and need to add into it also return "" if the number is less than 1 but unsure where to place it, sure it will take someone here 2 seconds

thanks for your help , Tim
 

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
647
Office Version
2013, 2010
Platform
Windows
try
Code:
=IF(ISERROR(SUM(F2-E2)),"",IF(SUM(F2-E2)<1,"",(SUM(F2-E2))))
 

Forum statistics

Threads
1,086,235
Messages
5,388,624
Members
402,127
Latest member
Jemx

Some videos you may like

This Week's Hot Topics

Top