Hello am working on the formula below,
=IF(COUNTA(F2)>0,"HSD",IF(COUNTA(F2)=0,"",IF(COUNTA(F2)=Standard Rate,"","HSD")))
What I need to do is ( if there is nothing in F2 populate nothing, if there is the word "Standard Rate" in F2 populate nothing, if there is something in F2 that is not the word "Standard Rate" populate HSD).
Does any one know how to write this formula?? Please Help??
Last edited by Mrgbolee; 10-21-2010 at 12:48 PM.
Maybe this:
Please Login or Register to view this content.
It Work!!!! Thank you
Wow, and its much simpler, never used an OR before. Thanks again.
You're welcome. Always glad to help.
Don't forget to mark your thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks