Looking for help in trying to trim down a calc which is too big to fit in the field rule box. Not sure if there is an easy way to do this or if I have to look at other means of doing which always means trouble :)
The problem arises because we rent DVDs and they have varying prices for diff days as well as diff prices according to the members club status. Here is what I've done, unfortunately I cant test it but it should be pretty close.
If anyone has a more efficient way of achieving the same end, please feel free to add your input, it will be much appreciated.
IF(TRANTYPE="1".AND.MEMBERCLASS="Rental Only".and.Newrelease"---",Rental1,
IF(TRANTYPE="2".AND.MEMBERCLASS="Rental Only".and.Newrelease"---",Rental2,
IF(TRANTYPE="3".AND.MEMBERCLASS="Rental Only".and.Newrelease"---",Rental3,
IF((TRANTYPE="3".AND.MEMBERCLASS="Rental Only".and.Newrelease"---".and.dow(Date())"Rental Only".and.Newrelease"---",vipr1,
IF(TRANTYPE="2".AND.MEMBERCLASS"Rental Only".and.Newrelease"---",vipr2,
IF(TRANTYPE="3".AND.MEMBERCLASS"Rental Only".and.Newrelease"---",vipr3,
IF(TRANTYPE="3".AND.MEMBERCLASS"Rental Only".and.Newrelease"---".and.dow(Date())"Rental Only".and.Newrelease="---",vipw1,
IF(TRANTYPE="2".AND.MEMBERCLASS"Rental Only".and.Newrelease="---",vipw2,
IF(TRANTYPE="3".AND.MEMBERCLASS"Rental Only".and.Newrelease="---",vipw3,
IF(trantype="Buy",Sale*Instock,Sale*Instock,IF(TRANTYPE="Swap".AND.OUT="Out".AND.IN"In",SWAP,
,0)))))))))))))))
As you can see my calc skills are not to flash so any assistance would be appreciated. As usual, thanks in advance :)
The problem arises because we rent DVDs and they have varying prices for diff days as well as diff prices according to the members club status. Here is what I've done, unfortunately I cant test it but it should be pretty close.
If anyone has a more efficient way of achieving the same end, please feel free to add your input, it will be much appreciated.
IF(TRANTYPE="1".AND.MEMBERCLASS="Rental Only".and.Newrelease"---",Rental1,
IF(TRANTYPE="2".AND.MEMBERCLASS="Rental Only".and.Newrelease"---",Rental2,
IF(TRANTYPE="3".AND.MEMBERCLASS="Rental Only".and.Newrelease"---",Rental3,
IF((TRANTYPE="3".AND.MEMBERCLASS="Rental Only".and.Newrelease"---".and.dow(Date())"Rental Only".and.Newrelease"---",vipr1,
IF(TRANTYPE="2".AND.MEMBERCLASS"Rental Only".and.Newrelease"---",vipr2,
IF(TRANTYPE="3".AND.MEMBERCLASS"Rental Only".and.Newrelease"---",vipr3,
IF(TRANTYPE="3".AND.MEMBERCLASS"Rental Only".and.Newrelease"---".and.dow(Date())"Rental Only".and.Newrelease="---",vipw1,
IF(TRANTYPE="2".AND.MEMBERCLASS"Rental Only".and.Newrelease="---",vipw2,
IF(TRANTYPE="3".AND.MEMBERCLASS"Rental Only".and.Newrelease="---",vipw3,
IF(trantype="Buy",Sale*Instock,Sale*Instock,IF(TRANTYPE="Swap".AND.OUT="Out".AND.IN"In",SWAP,
,0)))))))))))))))
As you can see my calc skills are not to flash so any assistance would be appreciated. As usual, thanks in advance :)
Comment