Get instant live Excel expert help with IF Functions

Formatting dates will not stick if we refresh the data

On the "Input Scores" tab formulas in E and I columns are being used to return 0.5 or 0 value based on C or G value being equal to each other but I want it to return 0 if both are zero. Hope I got this explained right! Thanks in advance for any help. FYI, I am a mid level excel novice.

Im trying to make a formula stating if a cell within A:A equals a date in january AND if a cell in column E:E equals "X" ,count.

I have a data with 4 columns I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row

SPREADSHEET SOFTWARE USED: Microsoft Excel 97-2004 (.xls) MY QUESTION IS ABOUT: IF STATEMENT DESCRIPTION: I have a data with 4 columns I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row

I would like to create a function that would look up the Max value in Experiment. Then compare that value to the results values in the same category (A, B or C). If both values are equal, then it is alright. If not, highlight the category (A, B or C) on top

I found how to do an if/then statement but I cannot find out if there is a way to make it do what I want. I want to know if one cell is greater than another cell by a certain amount. For example, is cell A2 greater than cell A1 by more than .25.

I'm trying to return a numerical result for 3 text conditions across a wide spreadsheet. If text in a cell is "on", "off" or "down", depending on which a different cell's numerical result will be returned

I want 2 "if" formulas in one cell

Basically for each entry in the "Packet Games" section we can have multiple winners and they can be both Single and Double winners. One single winner would win 40.00 as long as they are the only winner, and the payout needs to round up to the nearest .25 If n15>0 then calculate using O13 to complete Roundup(O13/C5/0.25,0)*0.25. The excel roundup function is not working