Formula help
 

What I'm trying to create is a formula where if the number in C2 (x) is
greater than 50, calculate x-50=y, add sum of D2*50 +(y*(1.5*D2))

Thanks in advance for any help you can offer!

Formula help
 

Hi Ashlea

if I understand your request, then
=IF(C250,D2*50+((C2-50)*(1.5*D2)),"")

The final "" or Null is what will be returned if C2<=50.
You can change this to whatever you want to be shown in that scenario.

--
Regards
Roger Govier

"Ashlea" wrote in message
...
What I'm trying to create is a formula where if the number in C2 (x) is
greater than 50, calculate x-50=y, add sum of D2*50 +(y*(1.5*D2))

Thanks in advance for any help you can offer!