evaluate text present in specific format in another column in Excel

**Abhishek021** · 06-07-2020, 02:09 AM

I have a text written as "12*14" in C4 and and number "1000" in B4. I want to calculate D4 as 1000-12*14

I have tried following, But both are not working here.

B4-NUMBERVALUE(C4)

B4-VALUE(C4)

**XOR LX** · 06-07-2020, 02:19 AM

Hi,

Is this a one-off exercise? Or are you looking for a generalisable solution to apply to equations with different operators, e.g. addition, subtraction, division, etc.?

If C4 always contains the product of two values:

=B4-PRODUCT(0+MID(SUBSTITUTE(C4,"*",REPT(" ",25)),{1,25},25),{1;1})

Regards

**Abhishek021** · 06-07-2020, 01:10 PM

Thanks, It worked for me.

**XOR LX** · 06-07-2020, 01:49 PM

You're welcome!

evaluate text present in specific format in another column in Excel

LinkBack

Thread Tools

Rate This Thread

Display

evaluate text present in specific format in another column in Excel

Re: evaluate text present in specific format in another column in Excel

Re: evaluate text present in specific format in another column in Excel

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Counting number of blank cells if specific text is present in another column.

Insert text if not present in specific columns

[SOLVED] Can Excel evaluate a formula for a column reference, then insert text in another cell?

[SOLVED] In a specific column find text and change the format

[SOLVED] Create formula to sum column total if specific text is present in second column

[SOLVED] Merge/unmerge based on whether specific text is present in a column

[SOLVED] SUM/COUNT column(s) based on specific value present within the column

Bookmarks

Bookmarks

Posting Permissions