I have made an excel formula using if statment to add a % to a figure depending on how high it is, can the following excel formula be created in php easily so the final figure can be created on the fly within my php script rather than creating sql dump file from excel file?
Code: Select all
=IF(D11<50,D11*0.4,IF(D11<100,D11*0.3,IF(D11<250,D11*0.2,IF(D11<500,D11*0.1,IF(D11<750,D11*0.1,IF(D11<1000,D11*0.1,IF(D11<2000,D11*0.06,D11*0.05)))))))+D11Cheers