First time here? Check out the FAQ!

2019-01-13 07:29:48 +0100 | received badge | ● Notable Question (source) |

2019-01-12 21:14:10 +0100 | 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 +0100 | 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 +0100 | 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 +0100 | 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 +0100 | 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 +0100 | 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 +0100 | received badge | ● Popular Question (source) |

2019-01-11 22:35:38 +0100 | 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 +0100 | received badge | ● Editor (source) |

2019-01-11 22:30:29 +0100 | 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 +0100 | 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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.