Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |