I am using below formula in one of my spreadsheets and it works the way I want it, with the exception of the first part.
=IF(ISBLANK('Mon Wr'!A2784:'Mon Wr'!E2784),"" will leave the cell with the formula blank when I do not have any data in cells A2784, B2784, C2784, D2784 and E2784 on the sheet named 'Mon Wr'. Great, that is what I expected.
It will return a value when there is data in cell E2784, also as expected but remains blank when there is data in cell A2784 or B2784 or C2784 or D2784.
Below is the complete formula I am using.
=IF(ISBLANK('Mon Wr'!A2784:'Mon Wr'!E2784),"",IF(LEFT('Mon Wr'!A2784,5)="Agent",RIGHT('Mon Wr'!A2784,5),E2775))
Can somebody please tell me where I go wrong?
Any help is very much appreciated.
=IF(ISBLANK('Mon Wr'!A2784:'Mon Wr'!E2784),"" will leave the cell with the formula blank when I do not have any data in cells A2784, B2784, C2784, D2784 and E2784 on the sheet named 'Mon Wr'. Great, that is what I expected.
It will return a value when there is data in cell E2784, also as expected but remains blank when there is data in cell A2784 or B2784 or C2784 or D2784.
Below is the complete formula I am using.
=IF(ISBLANK('Mon Wr'!A2784:'Mon Wr'!E2784),"",IF(LEFT('Mon Wr'!A2784,5)="Agent",RIGHT('Mon Wr'!A2784,5),E2775))
Can somebody please tell me where I go wrong?
Any help is very much appreciated.
