Formula: if a formula contains a number, then
MaxiQlaoui
-
DjiDji59430 Posted messages 4278 Registration date Status Member Last intervention -
DjiDji59430 Posted messages 4278 Registration date Status Member Last intervention -
Hello everyone,
My goal is to display in a cell the content of cell B1 if the formula contained in cell A1 includes a 108 (the formula can be either XX*108 or XX*45, with XX being any cell).
The formula I tested is as follows:
=IF(ISNUMBER(SEARCH("108",A1)),B1,0)
Unfortunately, I feel like Excel doesn't detect the 108 because it's part of a formula and doesn't appear directly in the cell.
If someone has a solution to this question, it would be a great help.
Thank you in advance,
PS: The next step, but optional, would actually be to find a formula that sums several cells in column A based on their equivalent in column B (based on the same criterion as above). But since =IF is not working, =SUM.IF is not my priority for now.
Configuration: Windows / Firefox 58.0
My goal is to display in a cell the content of cell B1 if the formula contained in cell A1 includes a 108 (the formula can be either XX*108 or XX*45, with XX being any cell).
The formula I tested is as follows:
=IF(ISNUMBER(SEARCH("108",A1)),B1,0)
Unfortunately, I feel like Excel doesn't detect the 108 because it's part of a formula and doesn't appear directly in the cell.
If someone has a solution to this question, it would be a great help.
Thank you in advance,
PS: The next step, but optional, would actually be to find a formula that sums several cells in column A based on their equivalent in column B (based on the same criterion as above). But since =IF is not working, =SUM.IF is not my priority for now.
Configuration: Windows / Firefox 58.0
1 answer
-
Hello,
Please attach a test file (with ALL the explanations and desired results) or, if possible, the relevant file; it's more convenient for the participants.
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file
3) Scroll to the bottom of the page to click on [Create the Cjoint link]
4) After a few seconds, the link will appear in blue; select it and click "Copy"
5) Return to the discussion, and in your reply message, click "Paste."
Best regards.
