Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |