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