2019-01-13 07:29:48 +0200 received badge ● Notable Question (source) 2019-01-12 21:14:10 +0200 edited question how to get around white space problem how to get around white space problem Here is the formula in column L: =IF(ISBLANK(D5)," ",(G5+K5)+(G5+K5)*$M$3) Column 2019-01-12 21:13:38 +0200 edited question how to get around white space problem how to get around white space problem Here is the formula in column L: =IF(ISBLANK(D5)," ",(G5+K5)+(G5+K5)*$M$3) Column 2019-01-12 21:12:28 +0200 commented question how to get around white space problem Lupp - there are whitespace characters. However, OpenOffice and Google treat them as NULL with the same value as 0. I ne 2019-01-12 21:11:45 +0200 edited question how to get around white space problem isblank problem Here is the formula in column L: =IF(ISBLANK(D5)," ",(G5+K5)+(G5+K5)*$M$3) Column D is units; column G 2019-01-12 20:20:31 +0200 commented question how to get around white space problem Lupp - there are whitespace characters. However, OpenOffice and Google treat them as NULL with the same value as 0. I ne 2019-01-12 20:04:55 +0200 commented question how to get around white space problem Lupp - there are whitespace characters. However, OpenOffice and Google treat them as NULL with the same value as 0. I ne 2019-01-12 10:48:53 +0200 received badge ● Popular Question (source) 2019-01-11 22:35:38 +0200 edited question how to get around white space problem isblank problem Here is the formula in column L: =IF(ISBLANK(D5)," ",(G5+K5)+(G5+K5)*$M$3) Column D is units; column G 2019-01-11 22:35:38 +0200 received badge ● Editor (source) 2019-01-11 22:30:29 +0200 edited question how to get around white space problem isblank problem Here is the formula in column L: =IF(ISBLANK(D5)," ",(G5+K5)+(G5+K5)*$M$3) This formula works in Open O 2019-01-11 22:29:29 +0200 asked a question how to get around white space problem isblank problem Here is the formula in column L: =IF(ISBLANK(D5)," ",(G5+K5)+(G5+K5)*$M$3) This formula works in Open O