=20/(c3+d3)
is the percentage that c3+d3 is of 20.
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
possible solution is to display only percentages using the formula:
=if(c3+d3=20,0.20,20/(c3+d3))
and format as percent.
If that's not what you want, give us specific examples of what you want
displayed in each circumstance.
There's always a solution.
--
Regards,
Fred
"Creolekitten via OfficeKB.com" <u24383@uwe wrote in message
news:63a118c081863@uwe...
Hello and thank you so much. I'm trying to find out what the percentage of C
& D combined would be of 20. I think I forgot some more of the formula also
because at the same time if C3 + D3 is < or not equal to 20 I need to
calculate what percentage of the sum of C3 & D3 would be of 20%. If the sum
is greater than or equal to 20 then the only value I want to print is 20
because that would max it but if less than 20 then what is the percentage of
the sum of C3 and D3.
Michael M wrote:
Hi
try this in F3
=IF(C3+D3=20,20,C3/D3)
The last bit could be slightly different because you don't explain what the
percentage actually is !!
HTH
Michael M
Can anyone please help me?
I can't seem to figure out the following formula:
[quoted text clipped - 4 lines]
greatly appreciated.
Thank you
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1