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;
}







1















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.



enter image description here










share|improve this question















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


















1















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.



enter image description here










share|improve this question















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














1












1








1








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.



enter image description here










share|improve this question
















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.



enter image description here







google-sheets formulas google-sheets-arrayformula worksheet-function regexextract






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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



















  • 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










2 Answers
2






active

oldest

votes


















1














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)





share|improve this answer































    0














    =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")))



    0






    share|improve this answer
























      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
      });


      }
      });














      draft saved

      draft discarded


















      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









      1














      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)





      share|improve this answer




























        1














        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)





        share|improve this answer


























          1












          1








          1







          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)





          share|improve this answer













          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)






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 9 hours ago







          Jahurul Islam
































              0














              =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")))



              0






              share|improve this answer




























                0














                =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")))



                0






                share|improve this answer


























                  0












                  0








                  0







                  =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")))



                  0






                  share|improve this answer













                  =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")))



                  0







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 4 hours ago









                  user0user0

                  10.4k71635




                  10.4k71635






























                      draft saved

                      draft discarded




















































                      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.




                      draft saved


                      draft discarded














                      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





















































                      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







                      Popular posts from this blog

                      VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

                      Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

                      Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...