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

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

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?

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.

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?

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