Questions & Answers for: 7 2 ifs

If condition problem Hi.... How to use the multiple cells in if condition. =if(A2="Car","Yes","No") (This working) =if(A2:A15="Car","Yes","No") (Please Answer) If ALL cells have to equal car to get a

what is the problem of that action script function fa() { return (996 % 511 * 5); } // End of the function var \x01= -2002 + \x01\x02(); for (\x01 = eval("\x01") + 120; eval("\x01") == 388; \x01 = ...

how can i use "IF" condition how i can use "IF" condition more than 50 times in excle-2003 Only 7 IF statements can be nested in the same formula, so you'd have use 8+ cells. The syntax for IF is: =IF

My Problem with IF Function ,Can u help Me PLZ :( when I use : IF(AND(C3>=95),"5.0",IF(AND(C3>=90),"4.75",IF(AND(C3>=85),"4.5",IF(AND(C3>=80),"4.0",IF(AND(C3>=75),"3.5",IF(AND(C3>=70),"3.0",IF(AND(C3>

I need coding with description C program coding to recognize nested if control statement and display number of levels of nesting The various combinations of these attributes may result in code that ...

How to create an object of VSI-Fax like in winfax How to create an object or class of VSI-Fax like in winfax you can use "WinFax.SDKSend8.0" ? Any code will be appreciated. For VB Private Sub ...

How to make a horoscope code to visual basic 6.0 Private Function Horoscope(pBirthDate As Date) As String Dim pMonth As Integer Dim pDay As Integer pMonth = Month(pBirthDate) pDay = Day(pBirthDate) If

How to Make the Matrix Raining Codes by Using Only Notepad? thats easy.. open notepad then copy and paste the following text @echo off color 0a cls :a set /a a=%random% if %a% geq 16384 set /a aa=1 if

I need help creating a nested if/and statement in Excel using the following parameters: If J28's value is less than 17 enter 0 If J28's value is 17-25 then multiply J27 by 12% If J28's value is 25-30 ...

How to convert percentages to a grading scale of 1 to 7 in excel. for example 50 to 59 = 4, 60 to 69 = 5, 70 to 79 =6 etc 7 grades so percent is 1 out of 100 a3 = actual percentage So cell A4=IF(A3>