Thread: Calculating Excel % and Concatenate

Hi,

This is probably really easy. I have the following Concatenate formula

=CONCATENATE("Response rate: ", B10/B9*100)

The above works fine when the number in B10 is lower than the number in B9. For example it returns 85% when the number in B10 is 6 and the number in B9 is 7. This is great.

However sometimes the number in B9 will be higher than in B10. How can I create a formula that gives me a return of 85% (using the above example) regardless of which number is higher or not?

Thanks

Hi Plumby

If i understoond well your point, you want ALWAYS, to get the percendage of the lowest price in the higher price...??

In this case, something like this, maybe works for you.

=IF(B10<B9;(B10/B9*100);IF(B10>B9;(B9/B10*100)))

Modify it, using the CONCATENATE formula also, as you like...

Hope to helps you.

seems strange but
=MIN(B9:B10)/MAX(B9:B10)*100
will do it