Thread: IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default IF function

On Aug 8, 12:03 am, Juan Bta.
wrote:
My problem is, if condition is met I need two true responses.
=if(c24="W";c20=20 "and" b20=c20+1;whatever)
Any help??


Generally, you cannot have two numeric values in a single cell. And
in the above, it appears that is not what you are trying to do after
all. The following appears to meet your needs:

In C20: =if(c24="W", 20, "")

In B20: =if(c24="W", c20+1, "")

These formulas return the null string where you wrote "whatever".

I presume that the only reason that you wrote c20+1 instead of 21
(since we know that C20 is 20) is that you want the flexibility of
changing the constant in C20 without having to also change B20.