Formulas

[davidtoth]

Hello to all. I am using Open Office 4.1.5 on Windows 10, what I am trying to do is change all the dollar amounts in a column by the same factor. I made a spreed sheet for items with different prices and I want to mark them up by the same multiplier, just can't figure out the formula . Any help would be appreciated .

[robleyd]

If you are new to spreadsheets, you may find the following to be useful resources.

[Tutorial] Ten concepts that every Calc user should know

OpenOffice Spreadsheet Tutorial for Beginners with Examples

Assuming you have your original price in A1 and want a new price in A2 that is 20% greater, and assuming that the value in A1 is a numeric value, not text, in A2 enter

Code: Select all

=A1 * 1.2

[davidtoth]

Thanks for the quick response, I'll check out the tutorial.