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







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


















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














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



















  • 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










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 3 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...