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

every month I get a very large list of recalls. and most of the time it is the same vin numbers from the previous month. is there any way I can have the previous month selected and if there is a duplicate of the vin then to copy it onto my new month sheet?
Solved by C. B. in 20 mins
I have a google sheet from which I send emails (using form mule addon) automatically and SMS to my customers. Due to security reasons I want to shift it to local server. My questions are 1.Will excel work well if multiple people access the sheet at the same time 2.how to make the app scripts and add on (which I did in google sheets) work with excel
Solved by E. C. in 16 mins
In column c I have one price and in column d I have another. If column D is greater than 0 then I want to use that price; however, if column D is equal to 0 I want to use the price in column C. I want a formula for column E that will choose the appropriate price from the columns to insert the price.
Solved by X. S. in 27 mins
I have a spreadsheet that computes a net golf score. The computation differs if a golfer plays from one set of tees (e.g., white) versus another set of tees (gold). Also, since not all golfer play each week, I want a blank space (v. a zero) in the column where the computation occurs. The formula I am trying to use is --
Solved by S. F. in 24 mins
I have a worksheet with dates in column D and various reason codes in culumn U. I need to report the number of occurrences if each reason by date
Solved by V. E. in 23 mins
I need to have a cell do a extended if then statement so that if one cell reads "T" it does a certain equation and if it doesn't. You can see it in the sheet "1-5" in B9
Solved by A. J. in 22 mins
I need a formula that will check the position (B1) and if this position is found on the range (C17:C36), it types the players name on "B2", "B3", etc., ordering by pick. For example Column D (TE) must show Engram (D2), Njoku (D3) Legget (D4). Is that possible ?
Solved by X. Q. in 26 mins
IF THEN statement answer not being used in calculation in another cell
Solved by S. J. in 25 mins
I have an issue with a formula. I have cells 65:68 in columns D and E, the sum of D needs to subtract the sum of E. Sometimes column D is blank. My formula isn't working =If((OR(D65:D68="")),sum(e65:e68),if(sum(d65:d68>0),sum(d65:d68)-sum(e65:e68))) cell R17
Solved by F. Q. in 22 mins
I'm stuck. I need a formula that will find the contents of cell A! in sheet1 in column C of sheet 2. If there's match then put in the contents of column A of the same row, into A3 on sheet1. Then to do the same for column B on sheet 1. Etc.
Solved by C. U. in 14 mins