[Solved] How do I use multiple formulas in the same cell?

Discuss the spreadsheet application

[Solved] How do I use multiple formulas in the same cell?

Postby YellerFurd » Mon Jan 13, 2020 1:34 am

:knock:
Searched all over this forum, Google, YouTube looking for an answer, and so far no luck. So what I need to be able to do is take 90% of 435 for me "=c2*0.9", and then round down to a 5 or 0 for me"=floor(d2; 5)". The problem is I want that done in the same cell vs having to have 2 when I only need 1 answer. Not sure of the way I'm supposed to type that in. Tried many different combinations only to get errors. Any help would be appreciated thanks.
Last edited by Hagar Delest on Mon Jan 13, 2020 9:04 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.7 on Windows 10
YellerFurd
 
Posts: 2
Joined: Mon Jan 13, 2020 1:08 am

Re: How do I use multiple formulas in the same cell?

Postby RusselB » Mon Jan 13, 2020 3:02 am

Welcome to the Forums.
In a case like this, the solution is actually simple.
Replace the D2 in the 2nd formula with your first formula, except for the = sign.
Thus you end up with
Code: Select all   Expand viewCollapse view
=floor(c2*0.9;5)

This is called combining formulas, since a single cell can only contain text, a number, or a single formula.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6157
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: How do I use multiple formulas in the same cell?

Postby YellerFurd » Mon Jan 13, 2020 6:01 am

Thanks, much appreciated. That will save me alot of time in the future.
OpenOffice 4.1.7 on Windows 10
YellerFurd
 
Posts: 2
Joined: Mon Jan 13, 2020 1:08 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests