Try something like...
...IF(ISNUMBER(FIND("OFF",'P1'!$U$13)),""...
Try something like...
...IF(ISNUMBER(FIND("OFF",'P1'!$U$13)),""...
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
THIS IS WHAT I GOT IT SAID false
=IF(ISNUMBER(FIND('P1'!$U$13="OFF","")),IF('P1'!$U$13="REQ OFF","",IF('P1'!$U$13="LOA","",IF('P1'!$U$13="VACA","",IF('P1'!$U$13>1,"X","")))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks