Thread: Formula terror
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Creolekitten Creolekitten is offline
external usenet poster
 
Posts: 1
Default Formula terror

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