Posted to microsoft.public.excel.misc
|
|
Formula terror
Thank you for your help it's amazing how one little missing operand can cause
so much problems.
Bernie
David Biddulph wrote:
Hello and thank you so much. I'm trying to find out what the percentage
of C
[quoted text clipped - 7 lines]
of
the sum of C3 and D3.
=20/(c3+d3)
is the percentage that c3+d3 is of 20.
You may prefer (c3+d3)/20 rather than 20/(c3+d3) ?
However, now you have a display problem, because if c3+d320, you want the
number 20 displayed, but if it's less, you want a percentage displayed. A
[quoted text clipped - 8 lines]
There's always a solution.
Perhaps =MIN((c3+d3)/20,1) and format that as percentage, you'll get 100% as
the maximum when C3+D320. With Fred's solution [having inverted the
20/(c3+d3), see above], you'd get the same answer for a total of 4 as for
20, as both would show 20%
You could dispense with the formatting as percentage, and use
=IF(C5+D5=20,20,(C5+D5)/0.2&"%")
but that would give a text answer in the percentage case, so couldn't be
used for further calculations.
---
David Biddulph
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1
|