Formula terror
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
"Creolekitten" wrote:
Can anyone please help me?
I can't seem to figure out the following formula:
If C3 + D3 is = 20 then the value of 20 should be place in F3 but if C3 + D3
is < or not equal to 20 then the percentage of the value of of C3 + D3 should
be placed in F3.
Is there such a way to write this formula in Excel. Any help would be
greatly appreciated.
Thank you
|