Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula...
I have two tables with many rows and columns. I want to set up a third table
that will calculate either the numerical inc(dec) in each cell or the pct inc(dec). The user can toggle between numbers and percents based on what he/she puts in an input cell. The formula is easy: (if inp="percent", (c5-b5)/b5, c5-b5). Can I set the format in that formula? I want to format as numbers, no decimal places, comma separating thousands for numbers and percent with 2 decimals for percents. Ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula...
Something along the lines of this might work for you:
=(if inp="percent", TEXT((c5-b5)/b5,"0.00%"), TEXT(c5-b5,"0")) -- Kevin Backmann "Steve" wrote: I have two tables with many rows and columns. I want to set up a third table that will calculate either the numerical inc(dec) in each cell or the pct inc(dec). The user can toggle between numbers and percents based on what he/she puts in an input cell. The formula is easy: (if inp="percent", (c5-b5)/b5, c5-b5). Can I set the format in that formula? I want to format as numbers, no decimal places, comma separating thousands for numbers and percent with 2 decimals for percents. Ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula...
I have two tables with many rows and columns. I want to set up a
third table that will calculate either the numerical inc(dec) in each cell or the pct inc(dec). The user can toggle between numbers and percents based on what he/she puts in an input cell. The formula is easy: (if inp="percent", (c5-b5)/b5, c5-b5). Can I set the format in that formula? I want to format as numbers, no decimal places, comma separating thousands for numbers and percent with 2 decimals for percents. This looks like a job for Excel's TEXT function. It’s documented in Excel's built-in Help. Each of the two alternative branches in the IF statement would use TEXT with the corresponding "format_text" argument. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|