Convert entire column of prices by 50%Working with names in Google SheetsAuto bracketed pricing in Google...
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
What killed these X2 caps?
Is it canonical bit space?
Is the Joker left-handed?
Did Shadowfax go to Valinor?
Stopping power of mountain vs road bike
Is it possible to run Internet Explorer on OS X El Capitan?
How to take photos in burst mode, without vibration?
Why do I get two different answers for this counting problem?
How do I write bicross product symbols in latex?
Is "remove commented out code" correct English?
Is it unprofessional to ask if a job posting on GlassDoor is real?
Arrow those variables!
How do conventional missiles fly?
Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?
If a Gelatinous Cube takes up the entire space of a Pit Trap, what happens when a creature falls into the trap but succeeds on the saving throw?
How is it possible to have an ability score that is less than 3?
What does it mean to describe someone as a butt steak?
Why is Collection not simply treated as Collection<?>
Intersection of two sorted vectors in C++
What is the word for reserving something for yourself before others do?
How to prevent "they're falling in love" trope
How to draw the figure with four pentagons?
Infinite Abelian subgroup of infinite non Abelian group example
Convert entire column of prices by 50%
Working with names in Google SheetsAuto bracketed pricing in Google SpreadsheetsApply formula when other is modifiedSUM of multiple values/variables in Google Sheets using “IFERROR”How to sum all positive values in Google Sheets based on whether the associated data in another column is uniqueReference entire row data or row-by-value from other sheetsHighlight Rows with Unique Values As Compared to Rows with Same ID# on a Different Sheetrank cell value by column values in google sheets formulaIs it possible to calculate in the background of a data validation cell?Copy formula every other row and every column
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have a large column of prices, however, sometimes the word [FIXED] also appears in these columns (see screenshot below).
I need to convert this price list to wholesale. All the products wholesale prices are exactly 50% of the retail price. I recently discovered more advanced features in google sheets - even playing with some scripts to accomplish more hefty tasks like this one.
Another issue I have is some prices have a .99 for example: 59.99 retail. The wholesale price for this would be 30.00 however.
Is there something I can do to convert all the prices in a specific column by half? 50% of the original value?
Any help would be much appreciated. I know basic js.
google-sheets formulas google-sheets-arrayformula worksheet-function regexextract
edited 4 hours ago
user0
10.4k71635
migrated from superuser.com 6 hours ago
This question came from our site for computer enthusiasts and power users.
add a comment |
I have a large column of prices, however, sometimes the word [FIXED] also appears in these columns (see screenshot below).
I need to convert this price list to wholesale. All the products wholesale prices are exactly 50% of the retail price. I recently discovered more advanced features in google sheets - even playing with some scripts to accomplish more hefty tasks like this one.
Another issue I have is some prices have a .99 for example: 59.99 retail. The wholesale price for this would be 30.00 however.
Is there something I can do to convert all the prices in a specific column by half? 50% of the original value?
Any help would be much appreciated. I know basic js.
google-sheets formulas google-sheets-arrayformula worksheet-function regexextract
edited 4 hours ago
user0
10.4k71635
migrated from superuser.com 6 hours ago
This question came from our site for computer enthusiasts and power users.
You basically would use=MID()or=SUBSTITUTE()to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.
– Eric F
10 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
10 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
10 hours ago
add a comment |
I have a large column of prices, however, sometimes the word [FIXED] also appears in these columns (see screenshot below).
I need to convert this price list to wholesale. All the products wholesale prices are exactly 50% of the retail price. I recently discovered more advanced features in google sheets - even playing with some scripts to accomplish more hefty tasks like this one.
Another issue I have is some prices have a .99 for example: 59.99 retail. The wholesale price for this would be 30.00 however.
Is there something I can do to convert all the prices in a specific column by half? 50% of the original value?
Any help would be much appreciated. I know basic js.
google-sheets formulas google-sheets-arrayformula worksheet-function regexextract
edited 4 hours ago
user0
10.4k71635
I have a large column of prices, however, sometimes the word [FIXED] also appears in these columns (see screenshot below).
I need to convert this price list to wholesale. All the products wholesale prices are exactly 50% of the retail price. I recently discovered more advanced features in google sheets - even playing with some scripts to accomplish more hefty tasks like this one.
Another issue I have is some prices have a .99 for example: 59.99 retail. The wholesale price for this would be 30.00 however.
Is there something I can do to convert all the prices in a specific column by half? 50% of the original value?
Any help would be much appreciated. I know basic js.
google-sheets formulas google-sheets-arrayformula worksheet-function regexextract
google-sheets formulas google-sheets-arrayformula worksheet-function regexextract
edited 4 hours ago
user0
10.4k71635
edited 4 hours ago
user0
10.4k71635
edited 4 hours ago
user0
10.4k71635
edited 4 hours ago
user0
10.4k71635
edited 4 hours ago
user0
10.4k71635
10.4k71635
asked 11 hours ago
Patrick
migrated from superuser.com 6 hours ago
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com 6 hours ago
This question came from our site for computer enthusiasts and power users.
You basically would use=MID()or=SUBSTITUTE()to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.
– Eric F
10 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
10 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
10 hours ago
add a comment |
You basically would use=MID()or=SUBSTITUTE()to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.
– Eric F
10 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
10 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
10 hours ago
You basically would use
=MID() or =SUBSTITUTE() to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.– Eric F
10 hours ago
You basically would use
=MID() or =SUBSTITUTE() to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.– Eric F
10 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
10 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
10 hours ago
1
1
Good thing we arent selling clothes. xD
– Patrick
10 hours ago
Good thing we arent selling clothes. xD
– Patrick
10 hours ago
add a comment |
2 Answers
2
active
oldest
votes
Just put the below formula in cell B2 and copy it to all other cells.
=if(A2="", "", iferror(left(A2, find("]", A2)), "") & round(right(A2, len(A2) - iferror(find("]", A2), 0)), 0)/2)
add a comment |
=ARRAYFORMULA(IFERROR(IFERROR(REGEXEXTRACT(A2:A, "[FIXED]"))&
TEXT(ROUND(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1-
(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1)*50%, 2),"#.00")))
answered 4 hours ago
user0user0
10.4k71635
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "34"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f127172%2fconvert-entire-column-of-prices-by-50%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Just put the below formula in cell B2 and copy it to all other cells.
=if(A2="", "", iferror(left(A2, find("]", A2)), "") & round(right(A2, len(A2) - iferror(find("]", A2), 0)), 0)/2)
add a comment |
Just put the below formula in cell B2 and copy it to all other cells.
=if(A2="", "", iferror(left(A2, find("]", A2)), "") & round(right(A2, len(A2) - iferror(find("]", A2), 0)), 0)/2)
add a comment |
Just put the below formula in cell B2 and copy it to all other cells.
=if(A2="", "", iferror(left(A2, find("]", A2)), "") & round(right(A2, len(A2) - iferror(find("]", A2), 0)), 0)/2)
Just put the below formula in cell B2 and copy it to all other cells.
=if(A2="", "", iferror(left(A2, find("]", A2)), "") & round(right(A2, len(A2) - iferror(find("]", A2), 0)), 0)/2)
answered 9 hours ago
Jahurul Islam
add a comment |
add a comment |
=ARRAYFORMULA(IFERROR(IFERROR(REGEXEXTRACT(A2:A, "[FIXED]"))&
TEXT(ROUND(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1-
(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1)*50%, 2),"#.00")))
answered 4 hours ago
user0user0
10.4k71635
add a comment |
=ARRAYFORMULA(IFERROR(IFERROR(REGEXEXTRACT(A2:A, "[FIXED]"))&
TEXT(ROUND(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1-
(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1)*50%, 2),"#.00")))
answered 4 hours ago
user0user0
10.4k71635
add a comment |
=ARRAYFORMULA(IFERROR(IFERROR(REGEXEXTRACT(A2:A, "[FIXED]"))&
TEXT(ROUND(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1-
(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1)*50%, 2),"#.00")))
answered 4 hours ago
user0user0
10.4k71635
=ARRAYFORMULA(IFERROR(IFERROR(REGEXEXTRACT(A2:A, "[FIXED]"))&
TEXT(ROUND(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1-
(REGEXEXTRACT(TO_TEXT(A2:A), "d+.d+|d+")*1)*50%, 2),"#.00")))
answered 4 hours ago
user0user0
10.4k71635
answered 4 hours ago
user0user0
10.4k71635
answered 4 hours ago
user0user0
10.4k71635
answered 4 hours ago
user0user0
10.4k71635
10.4k71635
add a comment |
add a comment |
Thanks for contributing an answer to Web Applications Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f127172%2fconvert-entire-column-of-prices-by-50%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You basically would use
=MID()or=SUBSTITUTE()to narrow every item down to a numeric value since your text is always the same. Then simply apply your 50% formula and add the text back if desired.– Eric F
10 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
10 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
10 hours ago