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.
|