Easy excel formula

[tmmellor1981]

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]

try

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

 

[tmmellor1981]

works a treat thanks for your help