Forum Discussion

yacine.benbouriche's avatar
yacine.benbouriche
Copper Contributor
Jan 12, 2018

Excel formula question

 I have a calculation

for  X Terabytes

pricing structure: between 50 TB and 449 TB then $X

and between 450 TB and 499 TB then $X

and from 500 TB and beyond then $X

 

Here is the formulas I put but unfortunately that doesn't work:

=IF(B1>=500;(B1-500)*I6;0);(B1>50;B1<449;(50*I4);(B1>=450;B1<=499;(450*I5)))

can someone help me?

 

Thanks.

 

Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jan 12, 2018

    Hi,

     

    The syntax of your formula is wrong!

     

    So, replace this:

     

    =IF(B1>=500;(B1-500)*I6;0);(B1>50;B1<449;(50*I4);(B1>=450;B1<=499;(450*I5))

     

     

    With this:

     

    =IF(B1>=500;(B1-500)*I6;IF(AND(B1>50;B1<449);50*I4;IF(AND(B1>=450;B1<=499);450*I5;0)))

     

Resources