Understanding complex IF Formula within IF formula
I do not know what this formula is doing can you help?
=IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) Thanks for your help. DP |
Understanding complex IF Formula within IF formula
Hi,
The formula is looking at a worksheet called QBCash Breaking the formula down =IF(LEFT(QBCash!$B2,5)="Total","", 1. It looks at the contents of B2 and if the word 'Total' are the first 5 letters of the cell the formula return a null string IF(ISBLANK(QBCash!$B2),$A1, 2. If that isn't TRUE it then checks if B2 is blank and if it is it returns the value of cell A1. 3. If B2 isn't blank the value of B2 is returned =IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DP" wrote: I do not know what this formula is doing can you help? =IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) Thanks for your help. DP |
Understanding complex IF Formula within IF formula
Hi, Mike H:
Thanks for this information. It will help me decipher other similar complex formulas. "Mike H" wrote: Hi, The formula is looking at a worksheet called QBCash Breaking the formula down =IF(LEFT(QBCash!$B2,5)="Total","", 1. It looks at the contents of B2 and if the word 'Total' are the first 5 letters of the cell the formula return a null string IF(ISBLANK(QBCash!$B2),$A1, 2. If that isn't TRUE it then checks if B2 is blank and if it is it returns the value of cell A1. 3. If B2 isn't blank the value of B2 is returned =IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DP" wrote: I do not know what this formula is doing can you help? =IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) Thanks for your help. DP |
Understanding complex IF Formula within IF formula
Your welcome and thanks for the feedback
-- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DP" wrote: Hi, Mike H: Thanks for this information. It will help me decipher other similar complex formulas. "Mike H" wrote: Hi, The formula is looking at a worksheet called QBCash Breaking the formula down =IF(LEFT(QBCash!$B2,5)="Total","", 1. It looks at the contents of B2 and if the word 'Total' are the first 5 letters of the cell the formula return a null string IF(ISBLANK(QBCash!$B2),$A1, 2. If that isn't TRUE it then checks if B2 is blank and if it is it returns the value of cell A1. 3. If B2 isn't blank the value of B2 is returned =IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DP" wrote: I do not know what this formula is doing can you help? =IF(LEFT(QBCash!$B2,5)="Total","",IF(ISBLANK(QBCas h!$B2),$A1,QBCash!$B2)) Thanks for your help. DP |
All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com