Thread: If question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default If question

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

if this helps please click yes, thanks

"tss" wrote:

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