its still not working... cell is always blank even with
=IFERROR(1/(1/INDIRECT(LEFT(NAME,FIND(" ",NAME)-1)&"_Gas_Saturday_Initial")),"")
I even tried making a cell with FIRSTNAME_LASTNAME set up a defined name of DEFINED_NAME and change formula
=IFERROR(1/(1/INDIRECT(LEFT(DEFINED_NAME(" ",DEFINED_NAME)-1)&"_GAS_SATURDAY_INITIAL")),"")
still blank
Last edited by techmaster29729; 06-13-2017 at 11:16 PM.
how do i just keep it simple... like
if name = "John Doe" do ISBLANKelse if name = "Jane Doe" do ISBLANK else if name = "Jean Doe" do ISBLANK
=IF(NAME="John Doe",IF(ISBLANK(JOHN_GAS_SATURDAY_INITIAL),"",JOHN_GAS_SATURDAY_INITIAL),)
IF(NAME="Jane Doe",IF(ISBLANK(JANE_GAS_SATURDAY_INITIAL),"",JANE_GAS_SATURDAY_INITIAL),)
IF(NAME="Jean Doe",IF(ISBLANK(JEAN_GAS_SATURDAY_INITIAL),"",JEAN_GAS_SATURDAY_INITIAL),)
tried this and it doesn't work results in #VALUE error!
well, i think I finally figured it out!
=IFS(
NAME="John Doe",IF(ISBLANK(JOHN_GAS_SATURDAY_INITIAL),"",JOHN_GAS_SATURDAY_INITIAL),
NAME="Jane Doe",IF(ISBLANK(JANE_GAS_SATURDAY_INITIAL),"",JANE_GAS_SATURDAY_INITIAL),
NAME="Jean Doe",IF(ISBLANK(JEAN_GAS_SATURDAY_INITIAL),"",JEAN_GAS_SATURDAY_INITIAL))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks