Help with formula...

S

Steve

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

Kevin B

Something along the lines of this might work for you:

=(if inp="percent", TEXT((c5-b5)/b5,"0.00%"), TEXT(c5-b5,"0"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NEED HELP WITH A FORMULA PROBLEM 6
Sum Formula with variable range 2
Formula Help to Calculate Quarterly Results 4
Formula in opposite direction 1
Custom Format - Percent 3
Help with a formula 2
What is wrong with this IF formula 7
Difficult Formula 9

Top