excel formula syntax

D

Dave Peterson

First, the formula has to go into T2:

=if(a2=c1,s2,"not equal")

replace that "not equal" string with what you want to see if A2 doesn't equal
C1.
 

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

Excel - Wich Function should I use? 1
concatenate won't work 6
Dragging formulas to new cells 7
Multiple IF formulas 8
Lookup Question 3
VBA Coding Help for Beginner 0
Is there anything wrong with the syntax 2
Conditional Formating Issue 1

Top