[Solved] conditional formating

Discuss the spreadsheet application
Post Reply
spoppovich
Posts: 4
Joined: Tue Mar 07, 2017 3:58 pm

[Solved] conditional formating

Post by spoppovich »

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
Last edited by robleyd on Tue Nov 21, 2017 4:01 am, edited 1 time in total.
Reason: tagged [Solved] by robleyd
OpenOffice 4.0.1 on Windows 10
User avatar
soby
Volunteer
Posts: 150
Joined: Sat Oct 29, 2016 10:49 am

Re: conditional formating

Post by soby »

try this in C1

=if(A1="";"";B1-A1)
Libre Office 6.1 dev homebuild Open Office 4.1.5 on Slackware64 current
spoppovich
Posts: 4
Joined: Tue Mar 07, 2017 3:58 pm

Re: conditional formating

Post by spoppovich »

thank you

exactly what i need.

Thanks again
OpenOffice 4.0.1 on Windows 10
Post Reply