i am trying to create a check register that includes rounding up and adding extra savings built in.
column A has a dollar amount
Column B is a roundup of the cell in column A plus 1
Column C is the Difference between column B and A
I would like it to only have a value if column A has a value.
Any help would be appreciated
Thanks
[Solved] conditional formating
-
- Posts: 4
- Joined: Tue Mar 07, 2017 3:58 pm
[Solved] conditional formating
Last edited by robleyd on Tue Nov 21, 2017 4:01 am, edited 1 time in total.
Reason: tagged [Solved] by robleyd
Reason: tagged [Solved] by robleyd
OpenOffice 4.0.1 on Windows 10
Re: conditional formating
try this in C1
=if(A1="";"";B1-A1)
=if(A1="";"";B1-A1)
Libre Office 6.1 dev homebuild Open Office 4.1.5 on Slackware64 current
-
- Posts: 4
- Joined: Tue Mar 07, 2017 3:58 pm
Re: conditional formating
thank you
exactly what i need.
Thanks again
exactly what i need.
Thanks again
OpenOffice 4.0.1 on Windows 10