|
IF Functions
What type of folmula would respond to the following conditions: IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555 IF Any Cell in Column AA= A2 and Any Cell Column AB =B1 then C1=666 IF Any Cell in Column AA= A1 and Any Cell in Column AB =B2 then C1=444 IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=777 help me please? Alex |
Try...
=IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B1),555,IF(COU NTIF(AA:AA,A2)*COUNTIF( AB:AB,B1),666,IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B 2),444,IF(COUNTIF(AA:AA ,A2)*COUNTIF(AB:AB,B2),777,"")))) Hope this helps! In article , "ALex" wrote: What type of folmula would respond to the following conditions: IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555 IF Any Cell in Column AA= A2 and Any Cell Column AB =B1 then C1=666 IF Any Cell in Column AA= A1 and Any Cell in Column AB =B2 then C1=444 IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=777 help me please? Alex |
| All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com