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!”

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

Wanting to automatically generate a chart from sheet1 to sheet3 that sorts by group name AKA column 1 headings (EXAMPLE 1, EXAMPLE 2, EXTRA,) and organizes it by color green,blue,yellow, then red. *Notice* that color is based on Conditional Formatting tool and is order specific in order to give me the coloring scheme that is wanted. For now we will ignore sheet2. Thanks
Solved by B. B. in 21 mins
I need a formula to separate and order data that I have pasted into Excel, currently all in one section (HC-One 9.4 352 CH, 1 ADC • P) and I want the number previous to CH to be ordered numerically largest to smallest
Solved by D. S. in 17 mins
I need to formula to test my data. I am looking for duplicates with two conditions: ord instant (time) (column A) AND ord erx id (column c). The ord instant for a drug and ord erx CANNOT occur at the same time therefore it is a duplicate. Also I do not have access to google docs, I would need an explanation in the text box. Thank you
Solved by M. H. in 19 mins
Hi I need to calculate several IF AND OR statements. 1) if value is =1 return 1 2) if value is = 2 return 2 3) if value is greater then 10 but less then 50 multiple by .10 (10%). if value is greater then 5 return 5 4) if value is greater then 50 multiple by .25 (25%). if value is greater then 10 return 10
Solved by K. A. in 29 mins
I am using excel to highlight duplicates and order research papers for a systematic review. My initial search had roughly 300 papers. I have done a new search which includes 400 or so papers. (each paper has various columns, such as Title, authors, abstract) etc. In theory my new search should include all 300 papers from the initial search (which I have already assessed). I match these old ("already assessed") papers to the new ones to (a) highlight new papers I must assess and (b) ensure that I am not missing any papers
Solved by S. Y. in 28 mins
I need to match the serial numbers to pull the email, model and organization group in the Invoice tab
Solved by I. J. in 20 mins
How do I expand or collapse several rows under a header in Excel?
Solved by M. H. in 19 mins
I have a spreadsheet where row 1 is dates, spanning 3 columns each. Columns A-C are Product Name, Order #, and Case Count, respectively. D-F (repeating indefinitely) are Sold, On Hand, and Order, respectively. I want a dynamic formula applied to the whole sheet that checks row 1 for today's date and the order column for quantities greater than 0. Currently, I have =AND(A$1=TODAY(),C>0) and it works as expected. The problem is, it's formatting cells in the wrong column (relative A as opposed to relative C). Is there a way to alter this so formats relative column C?
Solved by T. Q. in 13 mins
Level A items Fruits Veggies Nuts Under each Level A item there are an inconsistent number of "Level B items" For example: Level B items Under fruits you have apples and Oranges (2 items) Under veggies you have corn potatoes and peas (3 items) Under nuts you have peanuts (1 items) I need to set something up so that I can type in a Level A Item (in random order) and have a row of data created for each Level B item. So if Sheet 1, Column A is: Fruits Veggies Nuts Then Sheet 2 Column A would look like: Row 1 = apples Row 2 = oranges Row 3 = Corn Row 4 = Potatoes Row 5 = Peas Row6 = Peanuts And so on and so on.
Solved by F. E. in 13 mins
What apps and or API integrations (minsheets=contacts) to take my sheet to "(build with a bot made sheet to sale funnels to app/api/bot= email generator/erifyer+automated+insights+smartsheet+giphy+zapier+taskbot+growthbot+freshdesk+project insights+formatter+Zendesk+sheets+slack+webhooks+allais) needed and please of your choice of BI bot and what other apps/apis bots to create the most responsive and interactive database ever w/ embed bot/app fully able create and sort sheets maps dcs graphs & filtered data as i command so it monetized for $ philanthropic to change the world like kiwi+excelchat+insightly+BI Also Linkin url to email ethical
Solved by C. U. in 22 mins