Hey
I am new to Clac
How can I write a function/formula to multiply cell value in one column (J) if there is a specific value (stat_cost) in the same row in A column
Ill guess it be something like
IF A (1-1778 number of rows?) = "stat_cost" then J (in the same row how to point that out?) * 3
Appreciate any help
Multiply cell value in one column if there is a specific
-
- Posts: 6
- Joined: Sun Jun 23, 2019 1:41 am
Multiply cell value in one column if there is a specific
OpenOffice 3.1 on Windows Vist
Re: multiply cell value in one column if there is a specific
IF is not a solution, particularly when you can not describe the problem in full detail.
So the factor should be 3 if the corresponding text in J happens to be "stat_cost". What if it is not "stat_cost"?
Is there some list of allowed values for column J?
So the factor should be 3 if the corresponding text in J happens to be "stat_cost". What if it is not "stat_cost"?
Is there some list of allowed values for column J?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: multiply cell value in one column if there is a specific
=VLOOKUP( $J2 ; $X$1:$Y$10 ; 2 ; 0 ) * $A2
looks up J2 in X1:X10, returns the corresponding value from column Y and multiplies this looked up value with A2.
X1:Y10 is an arbitrary lookup table which starts like this:
stat_cost 3
... ...
[Tutorial] VLOOKUP questions and answers
looks up J2 in X1:X10, returns the corresponding value from column Y and multiplies this looked up value with A2.
X1:Y10 is an arbitrary lookup table which starts like this:
stat_cost 3
... ...
[Tutorial] VLOOKUP questions and answers
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 6
- Joined: Sun Jun 23, 2019 1:41 am
Re: multiply cell value in one column if there is a specific
It should be
If in a cell in column A value is "stat_cost" then (and only then, if it is not, do nothing with J) multiply value of corresponding J cell in the same row by three
There is a list for values for column A
There is no J as they will be random three digit
If in a cell in column A value is "stat_cost" then (and only then, if it is not, do nothing with J) multiply value of corresponding J cell in the same row by three
There is a list for values for column A
There is no J as they will be random three digit
OpenOffice 3.1 on Windows Vist
Re: multiply cell value in one column if there is a specific
Based on that specification:dontcareiii wrote:If in a cell in column A value is "stat_cost" then (and only then, if it is not, do nothing with J) multiply value of corresponding J cell in the same row by three
Code: Select all
IF(A1="stat_cost"; J1*3; J1)
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
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers