Hi Everyone I am trying to achieve a cell that is dependent on two different cells. Basically what I want to do is: *Item 1* If the contents of Cell U20 equals the contents of W12 or W13 the cell will equal a certain value. *Item 2*Depending on the date that a task was set, the status will change. Item 1 is the priority. This is what I have tried so far, but still drawing a blank: =IF(U20=W13,"C",IF(U20=W12,"On Hold"))+IF(K20>TODAY(),"G",IF(K20=TODAY(),"A",IF(K20<TODAY(),"R"))) =IF(AND(U20=W13,"C",IF(U20=W12,"On Hold")),IF(K20>TODAY(),"G",IF(K20=TODAY(),"A",IF(K20<TODAY(),"R")))) Any help would be appreciated.

Member Avatar
Member Avatar
+0 forum 2

I have an If Statement that isnt loading the right image any help would be great <?php if($formattedNum6 > $PeriodSalesTarget):{ echo '<img src="images/TargetMetGreen.png" alt="" />';} elseif($formattedNum6 > $CummulativePeriodSalesTarget):{ echo '<img src="images/TargetMet.png" alt="" />';} else:{ echo '<img src="images/TargetNotMet.png" alt="" />';} endif; ?> $formattedNum6 = 515,839 $PeriodSalesTarget = 1,366,000 $CummulativePeriodSalesTarget = 503,600 So it should show TargetMet.png but instead is showing TargetMetGreen.png If i change the PeriodSalesTarget to 999,999 it works so looks like it isnt treating the values as numbers but i dont know how to fix

Member Avatar
Member Avatar
+0 forum 2

I was informed the if-statement is incorrect. I can't find the syntax error ? var curDoc = app.activeDocument; var selall = app.executeMenuCommand("selectall"); var fillrmv = curDoc.pathItems[0].filled = false; if (app.activeDocument.pathItems[0].filled = true) { for (i=0;i>fillrmv;i++) { curDoc.pathItems[0].filled = false; }; };

Member Avatar
Member Avatar
+0 forum 18

Using swift programming import UIKit var str = "Hello, playground" func ls(array: [Int]) -> (large: Int, small: Int)//function { var lar = array[0] // array of large number var sma = array[0] // array of small number let num = 0 // check odd or even for i in array[1..<array.count] { if i < sma && num % 2 == 0 { sma = i }else if (i > lar) { lar = i } else if num % 2 == 0 { print("this is an even number") } else { print("this is an odd number") } } return (lar, …

Member Avatar
Member Avatar
+0 forum 5

I'm having an error when I run this code any ideas? When I run it and enter the code it works if I enter the same numbers I had entered before his turn, but if i enter different numbers I get Unhandled Exception: System.IndexOutOfRangeException: Index was outside the bounds of the array. using System; public class TicTacToe { public static void Main (string[] args) { int row = 0; int column; int[,] game; game = new int[3, 3] { { 0, 0, 0 }, { 0, 0, 0 }, { 0, 0, 0 } }; // Display array for (int …

Member Avatar
Member Avatar
+0 forum 3

Hey guys, I have a few Lists of strings containing elements saved from a Gridview on the page. (2 different gridviews with datasource from same database and table but showing different information) I need to write a logic which is ~10 if statements checking some conditions and then write a KML string (setting a different picture of a placemark in Google Earth). The code looks like that: [CODE] for (int i = 0; i < latList.Count; i++) // going through the list of latitudes and see how many are they - then create placemark for each one taking the latitude …

Member Avatar
Member Avatar
+0 forum 6

Hi there, am I doing something wrong with the if-statement? it either doesn't evaluate the conditions I've got in there or throw an error. $('button').click(function(){ var button = $($(this)).text(); console.log(button); // this logs the value of button as night or day depending on the button I click if(button == 'day'){ $('p').text(button); }else if(button == "night"){ $('p').text(button); }

Member Avatar
Member Avatar
+0 forum 4

I'm trying to switch "M" to "Mr." and "F" to "Ms." when the last name is selected in the listbox. When I clicked on the first name it worked, but when I clicked on anyother name, I got this error message: --Additional information: Index was outside the bounds of the array.-- The information in the text file is like this: Ball,Krystal,F,1981 Banks,Robin,F,1988 Burgher,Hamilton,M,1980 Early,Brighton,M,1989 Hedd,MT,M,1960 Hogg,Ima,F,1953 Knapp,Anita,F,1970 Overnout,Roger,M,1968 Psito,Arnie,M,1962 Teak,Anne,F,1939 And my code is as follows: Private Sub btnEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEnter.Click Dim names As IO.StreamReader = IO.File.OpenText("Info.txt") Dim lName As String = lstNames.Text …

Member Avatar
Member Avatar
+0 forum 1

So I have a function called start() and it has multiple if statements and I want all of them to run. [code=python] def start(): print """You have just woken up from a very long nap. You find yourself in a dimly lit cave. There is a patch of light in the far distance above you. There is a torch on the wall lighting the immediate area. There are dark passage ways in all directions.""" decision = raw_input(prompt) if decision == "take torch": inventory.append(items[0]) print "You took the torch." start_with_torch() # if you don't take the torch, you can't go anywhere …

Member Avatar
Member Avatar
+0 forum 1

Oh. btw admin! sorry about my earlier thread. i promise not to do something like that ever again :) anyway. i was having trouble with my project and its about Multiplication with loops. i started with a few codes and im really frustrated with what im doing now. please let mee fix this stuff i dont really know about looping statements @---@. thanks heres tha code. [CODE]import java.io.*; public class Multiplied{ public static void main(String [] args){ BufferedReader buffer= new BufferedReader(new InputStreamReader(System.in)); int i; int j; try{ {System.out.println("Enter a number: "); i = integer.parseInt(num.readLine()); } for (int i=1; i<=maxNo; ++i) …

Member Avatar
Member Avatar
+0 forum 6

I want to stick this [CODE] Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM 0 WHERE Id = 1", con) Dim reader As OleDbDataReader = cmd.ExecuteReader() If Not reader.HasRows Then MsgBox("Data does not exist") Else MsgBox("Data Exists") End If [/CODE] and this [CODE] If Inc <> -1 Then Dim cb As New OleDb.OleDbCommandBuilder(da) Dim dsNewRow As DataRow da.Fill(ds, "0")dsNewRow = ds.Tables("0").NewRow() dsNewRow.Item("Field1") = TextBox2.Text ds.Tables("0").Rows.Add(dsNewRow) da.Update(ds, "0") MsgBox("New Record added to the Database") con.Close() MsgBox("Database is now Closed")[/CODE] Into a If Then Statement that doesnt allow the second code to execute if the Data Exists And to allow code …

Member Avatar
Member Avatar
+0 forum 6

Here is the thing, as you might know AdMob has a `AdSize.*` function, where u put `Banner` to show banner ads, and AD_banner` for tablet banners, what i want to do is take a screen size of a device so that i could throw it in my if statement and then put the right banner for right device, i hope i was clear enough.So anyone can tell me how can i get the screen size of device? Thank u

Member Avatar
Member Avatar
+0 forum 1

Hi I have hard time connecting the if else statement because my teacher is telling us to use this kind of if else if (statement) if (statement) if (statement) condition else condition("error") end if else condition end if else condition end if this is a simple betting game can you please tell me how to arrange this code i really have hard time doing this in this way and there slight problems in this code [CODE] If (Val(txtInput.Text) >= 0 And Val(txtInput.Text) <= 9 And IsNumeric(txtInput.Text)) Then lblRandom.Text = Int(Rnd() * 10) Else MessageBox.Show("Wrong Input!", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1) SendKeys.Send("{Home}+{End}") …

Member Avatar
Member Avatar
-1 forum 11

Hello everybody, I have a xml socket server which get data from xml sockets out of actionscript3. Now I'm having a lot of if statements. Can I use another way to make my code more clean? Ivibot is a piece of hardware my school provided. LedBlink is a runnable class that let's a led blinking on a specific port. Engine1 and Engine2 are also Runnable classes that let the engine run for like 30 sec. By the way I'm dutch so that's why you see dutch words. Here some translation Kleur is Color and kast is Closet. Thanks in advance …

Member Avatar
Member Avatar
+0 forum 13

The End.