“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Formatting dates will not stick if we refresh the data

Solved by T. S. in 14 mins

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.

Solved by D. U. in 12 mins

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.

Solved by S. J. in 11 mins

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

Solved by G. U. in 22 mins

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

Solved by V. S. in 21 mins

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

Solved by G. C. in 27 mins

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.

Solved by V. A. in 26 mins

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

Solved by B. L. in 24 mins

I want 2 "if" formulas in one cell

Solved by I. J. in 21 mins

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

Solved by S. U. in 14 mins