# if statement

1. ### Solved Like charAt() but with integers

I'm trying to compare two ints, but only one index at a time. Something like charAt(), but using an integer variable instead of a string. Like this: //if userGuess index 0 is equal to code index 0, display a Y int code = 12345; string1 = JOptionPane.showInputDialog(null, "Please enter your...
2. ### Solved Excel macro or formula to autofill cells

This is just a curiosity post since I've been working a lot with excel lately. Is there anyway to create an IF formula to autofill cells based on a start date and then stop autofilling them on an end date? That probably seems really vague, so I'll attach an example. In my spreadsheet, I have...
3. ### Solved Formula Help - &IF

I am currently pulling data from another worksheet in my workbook and subtracting the previous month's totals from the current month's totals to get the total new items (Jan totals 1100 & Feb totals 1,200 = 100 new items gained from Jan to Feb) =Totals!E4-Totals!D4 (this formula is working...
4. ### Solved Excel Mac 2011 - Functions - IF statement

I have 2 sheets on my workbook what I want to do is compare (Sheet2)C = (Sheet3)V and if the result is true then copy (Sheet2)D text into (Sheet3)W. =IF(V2=Sheet3!C2, Sheet3!D2, "") but the result I had is always FALSE or "" Columns C and V are numbers Sheet2 C...