He Experts!
I have following formula
Why does this formula show result as "FALSE"?Please Login or Register to view this content.
If cell B56 is empty, then I need a result of "". i.e. blank result, but it shows FALSE word.
He Experts!
I have following formula
Why does this formula show result as "FALSE"?Please Login or Register to view this content.
If cell B56 is empty, then I need a result of "". i.e. blank result, but it shows FALSE word.
Last edited by caabdul; 02-15-2014 at 04:47 PM.
you dont have a false for this statement
IF(LEFT(B56,2)="on",
then you go straight to the TRUE nested IFs
IF(LEFT(B56,2)="on",
IF(LEFT(B$52,3)="Pla",RIGHT(Table!AN4,2)&"% Discount",
IF(LEFT(B$52,3)="Gol",RIGHT(Table!AO4,2)&"% Discount",
IF(LEFT(B$52,3)="Sil",RIGHT(Table!AP4,2)&"% Discount",""))), "need something here" )
so to get ""
IF(LEFT(B56,2)="on",IF(LEFT(B$52,3)="Pla",RIGHT(Table!AN4,2)&"% Discount",IF(LEFT(B$52,3)="Gol",RIGHT(Table!AO4,2)&"% Discount",IF(LEFT(B$52,3)="Sil",RIGHT(Table!AP4,2)&"% Discount",""))), "" )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Oh, Thanks
your welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks