[Solved] Conditional Formatting, Macro, VBA, IF !??!

[safetydave]

I have a spreadsheet with a simple calculation that I cannot figure out, sorry in advance.

Column a1 - Materials At Cost Say it is = 100.00
Column D1 - Actual cost(expenses) = 0.
Column E1 = Difference (between A1 and D1) = 100

However, I do not want to show any value in E1 until there are expenses entered into D1.

So how do I achieve that?

[RusselB]

Welcome to the Forums.
This is, simply, a formula matter. Nothing to do with Conditional formatting or macros.
In E1 enter the formula

Code: Select all

=if(D1=0;"";A1-D1)

Off topic, please use the User Control Panel, click the Profile tab, then Edit Signature...and change your forum signature to reflect what you are actually using.
OpenOffice 16 has not been released yet. The current version is 4.1.7

[safetydave]

Sorry copied and did not work, gave an error for "problem with this formula. asked me to put an apostrophe first (') but that didn't ended in just showing the entire formula.

[RusselB]

Try using the Select All link above the code, or just enter the code manually as I posted it.
Putting the ' in front will make it act as text, not a formula.

[Zizi64]

Sorry copied and did not work, gave an error for "problem with this formula. asked me to put an apostrophe first (') but that didn't ended in just showing the entire formula.

Please upload your sample fle here.

[Bill]

Sorry copied and did not work, gave an error for "problem with this formula. asked me to put an apostrophe first (') but that didn't ended in just showing the entire formula.

I can't duplicate the error. When I copied the formula, it worked perfectly.

Are you seeing this error in MS Excel 2016? A search for "problem with this formula" returned examples of problems in Excel, not in AOO Calc.

[safetydave]

Other than changing the cells in the formula from A1, D1 etc- Due to the header line info, changed the cells in formula to 2's and I couldn't get it to work. Sorry,

[Zizi64]

You are using some exotic (localized) quotation mark characters ”” instead of the pure (typewriter-type) quotation marks "".
Your formulas works for me with the "" marks.

Book1.ods

(12.32 KiB) Downloaded 79 times

[Zizi64]

Book1.xlsx
(11.83 KiB) Downloaded 1 time
___________________________________________
Dave P
Open OFfice 16, Windows 10 Pro 64 Bit

If you can save your document into .xlsx format, then you are using LibreOffice or Excel, but not OpenOffice.
The Apache OpenOffice can not save into .xlsx format. The recent AOO version is the AOO 4.1.7.
Please update your signature.

[safetydave]

Not sure why, but I walked away, came back struck my computer with a simple glancing blow with an eraser and voila.... entered the formula again and it worked. Thanks so much!!!!!!!