Feedback by UserVoice

Roy

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  4. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    Found another workaround for the decades until Excel does this. Fairly clever, the fellow used an AND() to hold his formula bit and also to hold his comment making sure to test the comment in a way he could be sure would come out true so it had no actual effect, only the true/false from the formula bit would matter as the comment half would always return true to AND().

    And basic example:

    =IF( AND( A1>=600, ISBLANK( "A1 holds the balance due on the loan. This formula checks that the balance is higher than the regular monthly payment. If not, it returns the formula for payoff result." ) = TRUE ), A30, C30 )

    and one can use Alt-Enter to make that appear on separate lines in the formula editor:

    =IF( AND( A1>=600, ISBLANK(

    "A1 holds the balance due on the loan. This formula checks that the balance is higher than the regular monthly payment. If not, it returns the formula for payoff result."

    ) = TRUE ), A30, C30 )

    so that the comment stands out. You can do that with the approach below too.

    Roy supported this idea  · 
    Roy commented  · 

    If it is of any assistance, you can wrap those text portions, EXACTLY as they are right now, do not drop the double quotes, in the N() function.

    So it would read:

    = 431 + N("explanation 1") - 1 + N("explanation 2")

    The N() function has been used since, oh, Shakespeare's day for this purpose (that of sort of commenting inside a formula).

    That won't help you convert directly, though one can use some, or a lot of, typing to convert formulas you'd hate to have lose their functionality.

    Another approach would use FORMULATEXT() to get them into strings, then standard text manipulation to locate where the double quotes are and insert the N( and the ) strings as appropriate, or break them into cells with Data to Columns and recombine via concatenation, or insert the needed characters, then use TEXTJOIN().

    Still probably hand done, so tedious, and not overly amenable to a macro. But it would give you a way to keep the functionality and probably see it last.

    Another way might be to check into Google's offering. I do not know but it might handle them as is so you'd have immediate functionality back while you consider what to get after and what to let die a sorry, unnecessary, death. Or to have use of while getting after it in a different way, rewriting the spreadsheets. One might, for instance, use them with Google while editing to put either the whole formula (probably easiest) into a Comment for each cell to keep the comments, then editing them out of the cell's themselves. Or one might one-step it extracting the comments into current Comment functionality leaving the formulas workable in the single edit. Or just edit them away, just Find and Replace ("*") wiping them all out, though I get the sense you don't want to do that!!!

    Good luck. Oh, you can always change over to using Excel for a rough database and writing those oh-so-wonderful PowerApps, paying their subscription pricing, overbuying licenses, and entering the future (the MS makes 10x the money for the same functionality future, that is). Watch Bill Gates (find it on YouTube) impress us about how benevolent monopolies are and how good they are for the advancement of mankind. You won't mind paying $300 a month for a few people to have the same abilities $50 a month used to buy... and you'll understand MS is just leading us into the future! It's the future and it's oh-so-bright!

    For the monopolies anyway.

  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  6. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  7. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  9. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  10. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy shared this idea  · 
  11. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  12. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  13. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  14. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  15. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  16. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    One beauty of ordering Excel to "format like sample" is it could compose the format of two parts:

    1. The normal symbols for the basic format, like "#,###.00", which could then be edited directly for variations and simple fixes when the sample is misunderstood or less than wonderfully conceived.
    2. An element that would be presented kind of like a picture would be, monolithic and not necessarily editable, though it'd be nice to be able to edit it.

    The second element could capture most of the uniqueness of the formatting one figures is meant. Excel could store it however IT felt it best represented. No interpreting our human mishmash and attempts to force things it never really intended. Also, no limitations on Excel in presentation of what we enter. (An example is generating a format that includes text (perhaps text for the currency symbol) of a language that writes right to left, but trying to ********* the left, not the right. Excel currently will let you enter it where you want it and then puts it at the right regardless ('cause you're a fool, apparently).) But this idea here would allow Excel to see how, exactly, you intended the character to be presented and it could just do it instead of seeing it and trying to apply the rules of conventional use for it that it is aware of... subverting you... and not applying rules it is not aware of... leaving you out to hang if it would have been good to help you with them. None of that. It sees where you have it relative to the other elements and puts it there, no need to check you on it and correct you... it'd just do it.

    (Seems like that'd be simpler for Excel and therfore desirable.)

    Roy supported this idea  · 
  17. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
  18. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    It'd be wonderful for loan interest type calculations. If it took an argument for "fraction of the month to the beginning or to the end":

    MONTHFRAC( date, 1 if to the end of the month OR 0 if to the beginning of the month )

    So a billing period's interest would be:

    =( MONTHFRAC("7/29/19",1) + MONTHFRAC("8/27/19",0) ) * (RATE/12) * PRINCIPAL

    and that'd allow easy adjustment for payments made in the period reducing principal for part of the period. Or interest and fees posted in the period. As with everything, there ARE substitute approaches that have stood the test of time, but the all suck due to complexity in the formulas. Besides, this place isn't about "dude, just do this complicated and unintuitive thing for the rest of your life." It's about what would improve things for a fair number of people.

    Roy commented  · 

    Voted!

    Not sure how complicated the formula you use is, and what follows is more than neeeded since this ought to be a function that just needs provided a date, but the below will calculate it without being ridiculously long (objectively that is):

    =1-TEXT(A1,"d")/TEXT(EOMONTH(A1,0),"d")

    for a date entered in A1. (It will convert the output of each TEXT() function for the arithmetic, so no need to wrap them with VALUE() functions. But the TEXT() function ARE needed to extract the day of the month without obnoxious work with strings.)

    Roy supported this idea  · 
  19. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    Back in the day... two "Back's" that is, the alte 80's, there was a program called "Baler" that ook a template you set up in Lotus 1-2-3 and converted it to an actual program written in Basic that not only ran on its own, but you owned it and could distribute it freely.

    It's chief purpose was to get spreadsheet functionality for given purposes nto the hands of people who did not own 1-2-3 or whose computers could not run it (due to memory limits and the other things they had to have running). Mainly that "did not want to spend the money for 1-2-3" part.

    For a long time Excel was essentially free, so it became ubiquitous, no one could seriously have a computer in business, say, without it. Now it costs, but nothing else has changed. So "that dog's hunted" as they say and Baler's main purpose doesn't really exist now.

    However, I loved it because I could set up templates and make programs without knowing any programming. No macros, no craziness. Set it up, you have data input (maybe that was the point) and things can be done with the data (quick POS or print charge card slips (remember the "knucklebuster" machines?), etc.). Lots of uses!

    Excel will never do this. It would give reason to not have Excel Everywhere. And they want you to pay a ton for PowerApps to do this, often in conjunction with Excel.

    BUT... anyone else in the world who programs could write a program like Baler to do exactly this. With much more power and ability since computers are so much better. And write out versions for different platforms, Mac, Linux, Android, etc.

    Folks have offerings that go the other way: program in real code, then those offerings take the code and create Excel files that perform the code. This would seem incredibly, utterly easier to accomplish than that!

    Baler had its limits, by the way, but so did literally (LITERALLY) everything else.

    But I voted, just in case Excel would do it. It was awesome and so would this be.

    Roy supported this idea  · 
  20. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 

Feedback and Knowledge Base