How to Replace cell data with data from separate cells ?

General discussion on OpenOffice Calc and its spreadsheets.

How to Replace cell data with data from separate cells ?

Postby FoxalTO » Mon Oct 20, 2014 5:36 am

Hi,

I'm a beginner, and need some help.
This is an example of what I would Manually enter:

A1: 44.94
B1: -134.71
C1: 45.47
D1: -132.76


So how would I get E1 to automatically display this below based on what I manually entered into A1 through D1:

E1: LATLONG (44.94 -134.71, 45.47 -132.76)

I'm wanting to find out a way so I don't have to type and paste the data all over again into parts of E1, which will make it twice as long to create.

I tried this below inside cell E1 but it does nothing:
LATLONG (=A1 =B1, =C1 =D1)

And help would be appreciated.

thanks in advance,
FoxalTO
 
Posts: 26
Joined: Tue Mar 25, 2014 6:25 am

Re: How to Replace cell data with data from separate cells ?

Postby Gregory A. Chase » Mon Oct 20, 2014 12:09 pm

Hello Everyone,

You can replace cell data by using the code given bellow:
Code: Select all
=IF(R2<(TODAY()-547);"YES";"NO")

if you want dates farther back in time than 547 days to return "YES".

thanks,
Gregory A. Chase
 
Posts: 22
Joined: Mon Mar 24, 2014 6:14 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 0 guests

cron