Mark Knecht wrote:
Hi,
I'm looking at a prebuilt spreadsheet in Excel and trying to
duplicate some of its functionality in OOCalc. I'm having trouble with
one formatting issue. In Excel there is a cell that has the following
contents:
="Option "&M33
M33 is a cell that contains a number from 0-160. In Excel when M33 is
1 or greater Excel displays
Option 1
or whatever number is in cell M33. However when M33 is 0 Excel
displays nothing. The cell is completely blank. It does not say Option
0.
When I try to build this myself, in Excel or OOCalc I see Option 0
in my version. How did the guy who created this spreadsheet get Excel
to do this?
I've checked all the formatting for the cell and I just don't see it.
Thanks,
Mark
You could do something like =IF(M33=0;"";"Option "&M33)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
