How to return value blank cell, if criteria do not match
Hi all,
=IF(ISNUMBER(SEARCH("BLOCK BOARD",D2)),G2*3,LEFT(E2,2)*G2/4)
I am using the formula above which works just fine, however it returns a #VALUE! when the target cell is empty
I would like the formula to return a blank cell is target cell is empty.
plz help
Dev.
Change formula to:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Dear OllyXLS,
You are really genius, formula worked great
Thank you so much for your help.
Dev.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks