[libreoffice-users] Re: Find string within a range of cells

After working on this for far too long last night I woke up to see
responses here. I def appreciate it - esp the examples sent directly.
This turned out to be one of those - you dont know what you dont
know until apply something and find - there are other hidden things
you dont know about HAHA

Changing the sheet layout for hidden columns, etc turned out to be
a real issue. What I ended up doing was:

If - this and this are true, get this number * this other value and add it
to the total.

That was added to another horrible long formula that I didnt create .. so
I had to be careful and not mess things up. Doing this type of checking to
make sure both values were there - because if the lb  was either empty or
just completely not there - it really screwed things up.

Wade
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy