Get instant free expert help with Excel and Google Sheets
“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
After adding a formula to add a space within a time field (ex: 12:38pm to 12:38 PM), using that cell in another formula. I'm trying to add date/time together, then subtract from another date/time I have combined.
Solved by O. J. in 24 mins
I am trying to build a IF formula based on two criteria, A pitcher who has started 4 games or less and has pitched more than 20 ip gets a bonus of 10% to ip, If he starts more than 4 games he gets 5% bonus to ip, if he starts more than 32 games he is unlimited
=IF($AE20>32,"UNL",IF($AJ20>24,$AJ20*1.05,IF($AE20>4,$AJ20*1.1, IF($AE20>=0,"not elig"))))
the results I get only adds 5% to all IPunder 32 GS
Solved by M. H. in 29 mins
I would like to summarize all the expense I will spend on my travel vacation.
Solved by F. A. in 29 mins
Trying to match data on 2 different tabs and im using addresses as a reference. I would like to get some help on this
Solved by G. E. in 20 mins
I need help setting up a rule for one of my formulas
Solved by Z. S. in 19 mins
Formula for: Max number of days for open ticket (data columns equal number days and a column for status (open, closed). Trying to use Max(if) statement
Solved by A. D. in 26 mins
please how can write this function in one cell
100 log [ h +7.57- 1.7(W) ^0.37
Solved by O. J. in 30 mins
i need a formula for a raise for each employee that also varies if they are working in two different cities as it varies by percentage
Solved by D. H. in 11 mins
how to flag a cell that does not contain a list of certain values
Solved by B. D. in 16 mins
Consolidate multiple excel files into one workbook, that updates automatically. We work on Excel 2016 mac version.
Solved by T. J. in 23 mins