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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 08:59 PM.