Get instant free expert help with Excel and Google Sheets

I need to create a graph based on the data that I will input later in my spreadsheet

In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.)

HOW CAN I MAKE A TALE FOR ONLY 6 COLUMN?

I have a .csv product file and one column has pricing data and the column next to it is empty. I need to fill in the data that matches the pricing column. For example if one of the box is 22.99 I need the empty colum box on same row to be certain number. And if another box is same price then same number gets filled. But if it's different number different number is filled and so forth. 1. Do you see column P (Header is Variant Price) 2. Next to the column on the left is column O (Header is Variant grams) (So you can see that it's filled with 136 right) 3. I have to basically fill the column O (variant grams) that corresponds to number range 4. So let's say if column P has number range from 1-8.99 I need the corresponding column on left (O Variant grams) to be a certain number. So same row, and so forth 5. Column O is prefilled with 136 and the following range will be used to fill in the Column O boxes and delete 136 (if it's 136 then just it will not delete it) range 0 - 7.99 = 136 grams (word gram will be omitted just need it to be a number) 7.99 - 14.95 = 226 14.96 - 26.95 = 317 26.96 - 35.95 = 431 35.96-53.95 = 1360 53.96 - 64.95 = 2276 64.96 - 74.95 = 2948 74.96 - 1000 = 3175 These are temporarily ranges, but as my shop prices and shipping weight changes, I'm hoping the formula or vba can be easily changed by me

hello need explanation on sheet and how to optomize it

I hold meetings and need to archive a transcript of the meeting. There are 3 sections of the transcript that need to be one a single document, but sortable between many historic documents. Example - doc 1, 2 3 have sections A,B & C. In addition to saving the 3 docs, each of A,B & C need to be seen in a separate document, independantly of the other sections and date in order.

Hi i would like to ask few questions on macros

Help with extracting data from a web page in to excel sheet

i need a formula to make a number become negative on it's own as soon as i change text colour to red of the cell

i would like to incorporate tabs 'training' and 'install' to the calendars on the attached.