Get instant live Excel expert help with IF AND Functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have an excel sheet with a list of 5 digit numbers in one of the columns. I want to copy these numbers to another spread sheet so I can manipulate the data. 1st issue I see is that I don't want all the numbers just the relevant ones. Example there are several 11111 numbers that I would like not copied to the new spread sheet, just all the others. 2nd issue, others will add, or subtract, 5 digit numbers to the list, so I also need my spread sheet to automatically expand or shrink on top of the before mentioned criteria. Looking for insight on how one might accomplish this.
Thanks
Solved by O. J. in 21 mins
I'm trying to combine the excel IF and OR functions with structured references and I keep getting a #NAME error.
Solved by I. D. in 28 mins
I need to be able to change font and orientation (not slanted and fit) on a waterfall chart
Solved by F. J. in 14 mins
using excel 2013. how do I expand or shrink coulmns?
Solved by O. B. in 14 mins
I need help modifying my existing formula. I believe this requires and IF(AND or IF(AND(OR
Solved by B. C. in 30 mins
Getting an error message
for my If and OR function. It first says I am missing an opening or closing parenthesis When I add an extra its saying I have an error with the formula
Solved by C. J. in 16 mins
I'm trying to use add an AND Statements to nested if and function in excel and it keeps coming back with too many elements - is there a way around this?
the formula is here:
=IF(AND(D5="Award",E5>0),($AR$8),””,ELSEIF(D5="Certificate",E5>0),($AS$8),””,ELSEIF(D5="Coaching",E5>0),($AT$8),””,ELSEIF(D5="Unit 1",E5>0),($AU$8),””,ELSEIF(D5="Unit 2",E5>0),($AV$8),””,ELSEIF(D5="Unit 3",E5>0),($AW$8),””,ELSEIF(D5="NA1",E5>0),($AX$8),"")
Solved by E. S. in 17 mins
I am trying to create an if and statement in excel. In column A I have a client number but there may be multiple rows with the same client number. I then need to sum the number of times a specific data validation from column C is present for each client number. Can you assist me with this?
Solved by D. H. in 20 mins
i have an issue with an if and statement. Here it is below:
=IF(AND(VLOOKUP(G2,'Campaign Dates'!A$1:B$14,2,0)<B2,VLOOKUP(G2,'Campaign Dates'!A$1:C$14,3,0)>B2),"Previous IO","Active")
Solved by A. S. in 11 mins
HI I need help with an If and and statement formula... for some reason it's not working for me
Solved by V. U. in 22 mins