# Get instant live Excel expert help with IF Functions

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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