Formula, Compare two cell's text and based on results output a number

		Microsoft Office Forums > Microsoft Excel > Excel
Formula, Compare two cell's text and based on results output a number

FAQ

Thread Tools

Display Modes

03-14-2016, 09:49 PM

xor

Windows 10 Formula, Compare two cell's text and based on results output a number

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

You are almost there.

Try changing K2="Medical", SUBSTITUTE.... to
K2<>"Medical","",SUBSTITUTE....
and if you want the output as number then precede the first IF with --

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Perform calc in active cell then highlight based on formula result	grexcelman	Excel Programming	4	01-12-2015 11:00 AM
How do I output text to a specific cell (x,y)?	norwood	Word VBA	2	01-31-2014 08:43 AM
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Creating formula based on if data is correct in cell	MattMurdock	Excel	1	08-06-2012 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:24 PM.