1 You could have said =IF(I5="","",CEILING(I5,12))

2 You don't need the SUM function in SUM(E5+H5+K5+L5-F5-M5-P5+1);
(E5+H5+K5+L5-F5-M5-P5+1) will do

3 If you want to combine your 2 formulae you could use
=IF(E5+H5+K5+L5-F5-M5-P50,CEILING((E5+H5+K5+L5-F5-M5-P5+1)/2,12),"")
--
David Biddulph

"pettyc" wrote in message
...
I want to add several columns, subtract several columns and if the result
is
gt zero I want to add 1 to it, divide by 2 and then round up to a multiple
of
12. If the result is 0 I want the result to be a space. I know about the
ceiling statement (sort of) but Can I do this in one statement somehow?

=IF(E5+H5+K5+L5-F5-M5-P50,SUM(E5+H5+K5+L5-F5-M5-P5+1)/2,"")

In a different column I can insert
=CEILING(I5,12) - but if the result is 0 it displays 0 instead of a space