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

Formula
 

You would need a helper cell somewhere that tells you want the current value
of AI10 is to test against.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tivpine" wrote in message
...
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