Formula

Hello guys, i am in an urge to solve this problem. So, the story behind is there’s a game designing challenge that i wanted to participate and i went trough the application form, They asked my to make experience formula for RPG games, BUT ! it had to be in MS Excel. Can you guys enlighten me ...

=round(average(Week1:Week4!E2:E24),2) is in worksheet 4 when I move it to worksheet 5 should be Week2:Week5

what is the formula to insert in the cell when I want to express "IF" values in F column are "high" than 100 or "low" than 100? Thanks

Ok so I've been working on a spread sheet for a gane i play (NWN) Im looks g for help on a formula to do the following if it's possible. I need to look in the range AV6:BF45 within that range I need to find out if a cell contains "weapon focus: A13" A13 refers to a cell value which changes...

Want to have dark green for positive number and red for negative number. Got the red done but putting green makes it like a lime which can't be read. Looking to put dark green but when I put dark green it won't accept it

I have heard all kinds of things about people being able to generate valid credit card numbers with security codes, expiration dates and pin numbers. Is this really [possible and if so, what are the formulas for doing this?

Hello there.To start with, you can see my setup at my signature but i can mention i have asus formula viii which has supreme FX onboard sound. I bought a pair of headset today and i have this problem.I initially plugged the headset to the front jacks , but the mic is catching some kind of static...

Hello, I'm attempting to apply the 'FORECAST' function to forecast a row of numbers 0 to 3. I selected a row of numbers to forecast. I then receive the following prompt: The formula you entered contains errors. If you do not wish to use a formula, insert a single quotation-mark before your...

Hi guys! I just finished installing a new motherboard (z170 maximus VIII formula) and installed all the necessary drivers. I also installed Asus AI Suite 3 but i won't stop crashing on startup (within the first 5 seconds of opening it) for unknown reasons. Even after uninstalling, running the...

Hi, My current rig is: ASUS ROG Maximus Viii Formula i7 6700K MSI twin frozr 980ti Corsair ax860i I am looking to purchase a decent set of headphones and was considering either the Beyerdynamic DT 880 or 990 250 Ohm. Do I need an amp to drive these? I have linked the mobo so you can see the...

I have a spreadsheet with one column that indicates what type of Ultrasound we performed (i.e. OB, MFM, GYN) - is there a way to put a formula in so that if F1 = OB then J1 will = 35.00 (for all 3) - i.e. if J1 = MFM then J1 will = 65.00... not sure how to fun the formula for multiple values in...

hello guys, i need a formula to find text used TWO times in word document

A few weeks ago I bought and installed a Maximus VII Formula and 4790k. A big part of the ROG marketing is the audio, which apparently is supposed to be pretty good. Apparently this iteration has a "separate" part of the PCB dedicated to audio. I do not know how much this differentiates...

I want the value of my first cell to equal the value of my second cell, but only if the third cell has a particular text

I have two columns of numbers, column A and column B. I need to run a formula that not only shows if any numbers from A show up in B, but also how many times they show up? Any help woukd be appreciated.

I need a formula to solve the following. It involves 3 cell's, I will say A1,A2,A3 I need to total only A2 into A3 if the value in A1 is less than 1. But if the value in either A1 or A2 is 1 or greater the total values of both A1 & A2 are added together and placed in A3

I have some Sennheiser G4me Zero headphones on order that should arrive any day now, and have ordered an Objective2 amp that will arrive a day or two after, but now I am wondering if I made a mistake with the Objective 2. My motherboard is the new ASUS Maximus VII Formula that has an...

Can someone please help me find the right formula for this spreadsheet? I need to subtract from the "Savings Account" to make the "Current Account Bank Balance" 0 (ZERO) only IF the "Current Account Bank Balance" is negative, otherwise not. Also, if the negative balance of "Current Account Bank...

I just got a Tiamat 7.1 and currently pluged it in to a Asus Maximus VI formula. I downloaded the razer surround sound and cant find the tiamat when configuration, and the outcome is i cant hear any bass from that headset. Any advise please ?

copying the formula sum(a1:a3) from a4 to b4 does show sum(b1:b3) in the b4 cell, but, value is still the same as a4. Changing a character (eg deleting and reentering the 3 in sum(b1:b3)) gets the correct value.