Convert entire column of prices by 50%Working with names in Google SheetsAuto bracketed pricing in Google...
Facing a paradox: Earnshaw's theorem in one dimension
Took a trip to a parallel universe, need help deciphering
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 to take photos in burst mode, without vibration?
What is the word for reserving something for yourself before others do?
Emailing HOD to enhance faculty application
What's the point of deactivating Num Lock on login screens?
Can a rocket refuel on Mars from water?
Is Lorentz symmetry broken if SUSY is broken?
How can I tell someone that I want to be his or her friend?
Why is Collection not simply treated as Collection<?>
What's the difference between 'rename' and 'mv'?
Doing something right before you need it - expression for this?
Should I tell management that I intend to leave due to bad software development practices?
If human space travel is limited by the G force vulnerability, is there a way to counter G forces?
Assassin's bullet with mercury
Etiquette around loan refinance - decision is going to cost first broker a lot of money
90's TV series where a boy goes to another dimension through portal near power lines
Neighboring nodes in the network
Combinations of multiple lists
Were any external disk drives stacked vertically?
In a Spin are Both Wings Stalled?
When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?
Why does Kotter return in Welcome Back Kotter
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 3 hours ago
user0
10.4k71635
migrated from superuser.com 5 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 3 hours ago
user0
10.4k71635
migrated from superuser.com 5 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
9 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
9 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
9 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 3 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 3 hours ago
user0
10.4k71635
edited 3 hours ago
user0
10.4k71635
edited 3 hours ago
user0
10.4k71635
edited 3 hours ago
user0
10.4k71635
edited 3 hours ago
user0
10.4k71635
10.4k71635
asked 10 hours ago
Patrick
migrated from superuser.com 5 hours ago
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com 5 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
9 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
9 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
9 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
9 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
9 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
9 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
9 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
9 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
9 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
9 hours ago
1
1
Good thing we arent selling clothes. xD
– Patrick
9 hours ago
Good thing we arent selling clothes. xD
– Patrick
9 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 3 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 3 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 3 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 3 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 3 hours ago
user0user0
10.4k71635
answered 3 hours ago
user0user0
10.4k71635
answered 3 hours ago
user0user0
10.4k71635
answered 3 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
9 hours ago
50% is a pretty big mark up on clothes by the way!
– Eric F
9 hours ago
1
Good thing we arent selling clothes. xD
– Patrick
9 hours ago