Text conditional

B

bmg59

What is wrong with this:
=if(d2="GROBBLE","Sent",if(d2="RASCLE","SENT","RECV"),"RECV")
 
M

Michael J. Malinsky

Take out the last "RECV"--the amended formula would be:

=if(d2="GROBBLE","Sent",if(d2="RASCLE","SENT","RECV"))

Mike
 
J

JE McGimpsey

Too many terms

Looks to me like this would work:

=IF(D2="GROBBLE","Sent",IF(D2="RASCLE","SENT","RECV"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display records based on specific values 2
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
A query based on a query and a Link table - Problems connecting 3
calulation 1
If Condition 0
425 Error message 1
Conditional Formatting - Comparative Versus Other Cells 4
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) 6

Top