General discussion on OpenOffice Calc and its spreadsheets.


Postby pollyG » Tue Nov 06, 2012 12:31 pm

Hi to all, I'm just finding a way to hold a formula in a particular cell so that I can enter number into the same cell at the same time and it is calculated by the formula. I really don't know whether it's possible or not, but just want to know. I hope some spreadsheet experts must be there who can clear doubts. Thanks in advance. :)
Posts: 1
Joined: Mon Oct 29, 2012 11:26 am
Location: Canada

Re: Question?

Postby forforumsysinfo » Tue Nov 06, 2012 12:42 pm

Sorry. I think it isn't possible. A single cell can hold either a number or a formula. You can't put both items in a particular cell at the same time. You have to use separate cells for the number and result of the formula. Anything more you want to know from us?
Regards. :)
N. Semm
Site Administrator
To know more about Data Recovery Services, visit SysInfoTools Data Recovery & Email Management Services.
Site Admin
Posts: 157
Joined: Sun Mar 21, 2010 10:32 pm
Location: United Kingdom

Return to Calc

Who is online

Users browsing this forum: No registered users and 1 guest