Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tivpine Tivpine is offline
external usenet poster
 
Posts: 7
Default 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