I currently have a formula =IF(C12=""),G12, LEFT(C12,4)) I would like to add the logical test if C12=ABC
How can I accomplish this?
I currently have a formula =IF(C12=""),G12, LEFT(C12,4)) I would like to add the logical test if C12=ABC
How can I accomplish this?
Do you mean this:
=IF(OR(C12="",C12="ABC"),G12,LEFT(C12,4))
??
Hope this helps.
Pete
Thanks a Bunch.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks