Formula help

  • Thread starter Thread starter Ashlea
  • Start date Start date
A

Ashlea

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!
 
Hi Ashlea

if I understand your request, then
=IF(C2>50,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.
 
Back
Top