Hi
I have this formula whcih is copied from a13 to z13. how can i shorten the same . tired xlookup but did not work
=IF(AND($B$2=$AB$4,$D$4=AD4),$AF$12/2,IF(AND($B$2=$AB$5,$D$4=$AD$4),$AF$5/2,IF(AND($B$2=$AB$6,$D$4=$AD$4),$AF$6/2,IF(AND($B$2=$AB$7,$D$4=$AD$4),$AF$7/2,IF(AND($B$2=$AB$8,$D$4=$AD$4),$AF$8/2,IF(AND($B$2=$AB$9,$D$4=$AD$4),$AF$9/2,IF(AND($B$2=$AB$10,$D$4=$AD$4),$AF$10/2,IF(AND($B$2=$AB$11,$D$4=$AD$4),$AF$11/2,0))))))))
where b2 and ab4 to ab11 are names ,d4 and ad4 are dates in the format apr-2008 apr 2030,,af 5 to af 12 are amounts.I would appreciate any help provided . I tried xlookup but no success
Shamsu
I have this formula whcih is copied from a13 to z13. how can i shorten the same . tired xlookup but did not work
=IF(AND($B$2=$AB$4,$D$4=AD4),$AF$12/2,IF(AND($B$2=$AB$5,$D$4=$AD$4),$AF$5/2,IF(AND($B$2=$AB$6,$D$4=$AD$4),$AF$6/2,IF(AND($B$2=$AB$7,$D$4=$AD$4),$AF$7/2,IF(AND($B$2=$AB$8,$D$4=$AD$4),$AF$8/2,IF(AND($B$2=$AB$9,$D$4=$AD$4),$AF$9/2,IF(AND($B$2=$AB$10,$D$4=$AD$4),$AF$10/2,IF(AND($B$2=$AB$11,$D$4=$AD$4),$AF$11/2,0))))))))
where b2 and ab4 to ab11 are names ,d4 and ad4 are dates in the format apr-2008 apr 2030,,af 5 to af 12 are amounts.I would appreciate any help provided . I tried xlookup but no success
Shamsu