[Solved] IF a cell is blank use info from another

Discuss the spreadsheet application

[Solved] IF a cell is blank use info from another

Postby Martync70 » Fri Oct 19, 2018 10:31 am

Hi

I'm trying to make up a project budget spreadsheet
What I want to do is have 2 columns 1st having an estimated cost (cell D4) and the second having the actual cost (cell F4)
What I want to be able to do is use the cost from Cell D4 if there is nothing entered in F4, and ideally have the color different (ie RED) to indicate its still an estimate not an actual cost.

Have played around with IF statements but always get an error.

Thanks in advance
Martyn
Last edited by robleyd on Mon Oct 22, 2018 11:51 pm, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Openoffice 4.1.5 on Windows 10Pro
Martync70
 
Posts: 2
Joined: Fri Oct 19, 2018 10:22 am

Re: IF a cell is blank use info from another

Postby robleyd » Fri Oct 19, 2018 10:48 am

You don't say what formulae you have actually tried; but one solution might involve IF() and ISBLANK().

My answer to a very similar question two days ago is in this post.
Cheers
David
Apache OpenOffice 4.1.6 RC1 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2168
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: IF a cell is blank use info from another

Postby Martync70 » Mon Oct 22, 2018 11:44 pm

Great works as wanted
Many thanks
Openoffice 4.1.5 on Windows 10Pro
Martync70
 
Posts: 2
Joined: Fri Oct 19, 2018 10:22 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests