Thread: Formula terror
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael M Michael M is offline
external usenet poster
 
Posts: 118
Default 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