Sum returning 0
thanks
"Niek Otten" wrote:
=IF(SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR 31,BT31)=0,"-",SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31 ,BT31))
--
Kind regards,
Niek Otten
"JR" wrote in message
...
Thanks for the reply. Is there a formula I can use instead?
"Niek Otten" wrote:
FormatCellsNumberCustom. In the Type box, enter
#;-#;-
--
Kind regards,
Niek Otten
"JR" wrote in message
...
Hello,
When using:
=SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31, BT31)
If hte cells are blank I get a 0 (zero). How can I write this formula
so
if
the cells are blank I get a - (dash)?
Thanks
|