Formula
Hi Guys,
I need help pls, i have this formula in AI10
=IF(AND(AJ10="",AK10=""),AM10,IF(OR(AJ10="RPT - "&AJ10,AK10="REG -
"&AK10),"",("RPT - "&AJ10&"REG - "&AK10)))
What am hoping i can get this formula to perform is alternater between the
alternatives in AJ10, AK10, AL10 and AM10.
Thanks Guys i know i can always count on you.
Cheers
|