If question

T

tss

I have three columns, A, B and C, I need a quick analysis / IF statement to
determine:
If A is between B and C,"A IS GOOD"
If A is below B, "INCREASE A"
If A is above C, "DECREASE A".

Thanks
 
J

Jacob Skaria

Try this with data in A1,B1,C1

=IF(A1<B1,"INCREASE A",IF(A1<=C1,"A IS GOOD",IF(A1>C1,"DECREASE A")))

If this post helps click Yes
 
E

Eduardo

Hi,
try
=if(A1<B1,"INCREASE A",if(A1>C1,"DECREASE A","IS GOOD")

if this helps please click yes, thanks
 
P

Per Jessen

Hi

Try this:

=IF(A2<B2,"Increase A",IF(A2>C2,"Decrease A","A is good"))

Regards,
Per
 

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

comparing data in excel 3
Copying formulas across columns 2
Scrabble Value calculation for Welsh words 0
SQLServer 2012 Replication (using C#) 1
Determine if a month falls between two dates. 5
Getting a value within a range 5
Comparison Function 6
Counting Days with variables 2

Top