=IF(ISERROR(INDEX($C$13:$C$534,MATCH(TRUE,INDEX(DT$13:DT$534>0,0),0))),"",IF((INDEX($C$13:$C$534,MATCH(TRUE,INDEX(DT$13:DT$534>0,0),0)))<1,"",IF(DT$10>0,(INDEX($C$13:$C$534,MATCH(TRUE,INDEX(DT$13:DT$534>0,0),0))))))
I keep getting the error message "FALSE" when DT10 = 0. Instead, l want the message to be "".
You're missing the "value_if_false" argument of your last IF statement. Perhaps changing it to the following will work:
Formula:
Please Login or Register to view this content.
Thanks Paul, that works. I was putting that final "" in different places without success but you got it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks