I think you were off 1 column (that last true in 1st line is a nother condition)
=IF(Z3="","",IF('Sheet2'!$B$3=FALSE,IF(W3="","",IF(W3>0,TRUE,FALSE))))
I think you were off 1 column (that last true in 1st line is a nother condition)
=IF(Z3="","",IF('Sheet2'!$B$3=FALSE,IF(W3="","",IF(W3>0,TRUE,FALSE))))
I tried this code, but it always comes back FALSE. I need it to be TRUE if 'Sheet2'!$B$3=TRUE & W3>0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks