Need a help. I want to perform a calculation in another cell of the same row, only if the particular cell in the same row contain (embodied) required text. Please suggest the formula.
Need a help. I want to perform a calculation in another cell of the same row, only if the particular cell in the same row contain (embodied) required text. Please suggest the formula.
You can use FIND or SEARCH to check if specified text is contained in a cell.
So something like =IF(FIND("SpecifiedText",A1)>0,YourFormulaHere,"")
This would look for the string "SpecifiedText" in cell A1. If it's found then your formula fires and if not the cell remains blank.
FIND is case sensitive and SEARCH is not.
Hope that helps.
BSB.
hi use find or search formula =FIND("embodied",A24,1)
Thanks for the suggestions. If specified test does not exist in the cell, it gives error. the correct formula I could finalize is ---> ISNUMBER(FIND("DIVI",UPPER($G959)))
Thanks.
Hi the below one will give as not applicable insted of error.
=iferror(ISNUMBER(FIND("DIVI",UPPER($G959))),"Not Avalilable")
or
=iferror(ISNUMBER(search("DIVI",($G959))),"Not Avalilable")
Sorry, I need to be specific....
(1) I want to count the number of cell in the column which contain he specific text, and/or (2) want to sum the figures in another row if the specific text is emodied in the first colum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks