If Statement greater/less than

[phiggins]

I was wondering if anyone could help me with this issue I am facing.

I need an if statement for this and not sure if it is possible.

If qty < 58 then multiply (b2) qty * 7.28$

if qty > 58 then multiply # of processors (h2)*202.68


I would appreciate any help

Thanks.

 

[VoG]

Perhaps

=IF(B2<58,B2*7.28,H2*202.65)

 

[Scott Huish]

What do you want to do if qty is = to 58?

 

[phiggins]

If the qty is = 58 , use 202.68$

Its for pricing for SQL Licenses.


Sorry I may have messed up on the top post.


Here is what I have so far

=IF(i11="SQL",


b2<58, b2*7.28$
b2>58 b2*202.68$


Sorry

 

[Scott Huish]

What do you then want to do if it is not SQL?

 

[phiggins]

Here is my entire IF statement, my boss has been adding stuff left and right everytime I submit it to him so he is driving me nuts.

At the end I just want to see if i11="SQL" and a formula to see if I can do that math equation above


=SUM(IF(J11="",(0),(IF(J11="Desktop with View",(((Sheet2!$H$6*Sheet1!B11))+((Sheet2!$H$9*B11)))*Sheet2!$L$2+(((Sheet2!$H$5*Sheet1!D11)+(Sheet2!$H$4*Sheet1!C11)+(Sheet2!$H$3*Sheet1!E11))*(Sheet1!B11)/$I$4)*Sheet2!$L$2,IF(J11="Desktop with Thin Client",(((Sheet2!$H$6*Sheet1!B11))+((Sheet2!$H$9*B11)))*Sheet2!$L$2+(((Sheet2!$H$2*Sheet1!B11)+(Sheet2!$H$5*Sheet1!D11)+(Sheet2!$H$4*Sheet1!C11)+(Sheet2!$H$3*Sheet1!E11))*(Sheet1!B11)/$I$4)*Sheet2!$L$2,IF(J11="Desktop Portal",((Sheet2!$H$9*B11))*Sheet2!$L$2+(((Sheet2!$H$5*Sheet1!D11)+(Sheet2!$H$4*Sheet1!C11)+(Sheet2!$H$3*Sheet1!E11)*(Sheet1!B11))/$I$4)*Sheet2!$L$2,IF(J11="Server",((Sheet1!B11*Sheet2!$H$14))*Sheet2!$L$2+((D11*Sheet2!$H$17)*Sheet1!B11)*Sheet2!$L$2+(((Sheet2!$H$4*Sheet1!C11)+(Sheet2!$H$5*Sheet1!D11)+(Sheet2!$H$3*Sheet1!E11)*(Sheet1!B11))/$I$4)*Sheet2!$L$2,"INVALID")))))+(IF(H11="Office STD",(Sheet1!B11*Sheet2!$H$10)*Sheet2!$L$2,IF(H11="",(0),IF(H11="Office Pro Plus",(Sheet1!B11*Sheet2!$H$11)*Sheet2!$L$2)))))+(IF(I11="Exchange Basic",(Sheet2!$H$20*Sheet1!B11)*Sheet2!$L$2,(IF(I11="",(0),(IF(I11="Exchange Ent Plus",(Sheet2!$H$21*Sheet1!B11)*Sheet2!$L$2,IF(I11="Exchange Enterprise",(Sheet2!$H$22*Sheet1!B11)*Sheet2!$L$2,IF(I11="Exchange Std",(Sheet2!$H$23*Sheet1!B11)*Sheet2!$L$2,IF(I11="Exchange Std Plus",(Sheet2!$H$24*Sheet1!B11)*Sheet2!$L$2))))))))))