Hello again.
I Have a little formula, (when I say little I mean long) as below
=IF(AND(DropList!$B$96=1,BE10>0),AZ10+(IF(INT($H$32)+($H$32-INT($H$32))/0.6<$E$72,0,IF($E$72<$E$74,MAX(0,(INT($H$32)+($H$32-INT($H$32))/0.6-$E$72-($E$74-$E$72)))*2+(IF(($H$32-$E$72)<($E$74-$E$72),(INT($H$32)+($H$32-INT($H$32))/0.6-$E$72),($E$74-$E$72)))*1.5,(INT($H$32)+($H$32-INT($H$32))/0.6-$E$72)*2))*$FY10+IF(DropList!$B$70=TRUE,$BM10,IF(DropList!$B$96=2,BP10/($E$85),IF(AND(DropList!$B$96=3,BE10>0),AZ10+((BP10/($E$85)/$L$61)),"")))))
When I test the logical expressions the fisrt argument (DropList!$B$96=1,BE10>0), it true value consist of the remiander of the equation,
In reality I need the false argument to commence from IF(DropList!$B$96=2 and the third argument from (DropList!$B$96=3,BE10>0)
can any one offer solution to manage the syntax so that the argument break up in the right way and return values instead of TRUE/FALSE?
I'm sure it could be written more economical, but its beyond me at the moment. it basically is a wages counter.
Thanks as always
johnny
I Have a little formula, (when I say little I mean long) as below
=IF(AND(DropList!$B$96=1,BE10>0),AZ10+(IF(INT($H$32)+($H$32-INT($H$32))/0.6<$E$72,0,IF($E$72<$E$74,MAX(0,(INT($H$32)+($H$32-INT($H$32))/0.6-$E$72-($E$74-$E$72)))*2+(IF(($H$32-$E$72)<($E$74-$E$72),(INT($H$32)+($H$32-INT($H$32))/0.6-$E$72),($E$74-$E$72)))*1.5,(INT($H$32)+($H$32-INT($H$32))/0.6-$E$72)*2))*$FY10+IF(DropList!$B$70=TRUE,$BM10,IF(DropList!$B$96=2,BP10/($E$85),IF(AND(DropList!$B$96=3,BE10>0),AZ10+((BP10/($E$85)/$L$61)),"")))))
When I test the logical expressions the fisrt argument (DropList!$B$96=1,BE10>0), it true value consist of the remiander of the equation,
In reality I need the false argument to commence from IF(DropList!$B$96=2 and the third argument from (DropList!$B$96=3,BE10>0)
can any one offer solution to manage the syntax so that the argument break up in the right way and return values instead of TRUE/FALSE?
I'm sure it could be written more economical, but its beyond me at the moment. it basically is a wages counter.
Thanks as always
johnny