Forum Discussion
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 ...
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)))
