# 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

I just want to get a general idea of how to use it if you can please
Solved by M. Y. in 27 mins
If 2 numbers are the same in Colum B and has the Value "D" in colum E, mark Both with "D" in colum F
Solved by T. J. in 25 mins
I am trying to say if the Priority level is H and if the item is still OPEN then turn the row red and flag.
Solved by K. Y. in 16 mins
what im trying to do for example: i want to be able to put a 1 in the columns of how many i sold. the price is at the bottom. so if i sold 2 websites and 1 Prime, i want to put a 2 in websites and 1 in prime then add the total at the end. then add the amount at the bottom. i hope this makes scene. thanks
Solved by E. W. in 26 mins
When i run the macro i get Run-time error '1004': The specified file wasn't found. this is the macro Sub PicturePopulator() Dim B As Range, r As Range, a As Range, _ t As Long, l As Long, w As Long, h As Long Set B = Range("B1:B1700") For Each r In B If r.Value <> "" Then MyFileAndPath = r.Value Set a = r.Offset(0, -1) t = a.Top l = a.Left h = a.Height w = a.Width ActiveSheet.Shapes.AddPicture MyFileAndPath, msoFalse, msoTrue, l, t, w, h End If Next r End Sub
Solved by D. W. in 13 mins
I need to know the formula as to average the individual GREEN, RED, and BLUE cell data together in the TOTAL GREEN, RED, and BLUE cell at the bottom that have data in the cells. So, if there is no data in the individual cells the AVERAGE formula ignores these cells, and only averages the ones with numbers. There is not a specific 'range' for this, but the individual cells for each color that needs to be AVERAGED.
Solved by O. B. in 23 mins
I want to set a formula to my document but can't figure out where to start. Basically if A4 to J4 are filled with text or numeric value than the row will be the color green. If cells A4 to J4 are not all filled with text or numeric value than the row will be the color red.
Solved by C. D. in 20 mins
This Feature Billing spreadsheet is something we use at our company for quoting our clients. We build custom software, and clients typically have very similar feature requests. The New Quote Tab is where a sales person would work. As they talk to the client, the put an "x" in the Selection column (Column H). This generates a price. With that said, each of those selections maps to another set of requirements that we want to communicate with our developers. The "Base-Components-With-Subtasks" tab represents the start of listing out the subtasks. If the sales person puts in X in row 2 of the New Quote tab, our developers need to know to build rows 2-5 of on the "Base-Components-With-Subtasks" tab. The output of this is supposed to be on the "Populated Story Map Tab." Currently I have it so it lists out all the items (and only those items) that are being selected from the New Quote tab, which is a great first step. But I also need it to list out all of the sub-tasks (in individual rows) that the selection maps to on the Base-Components-With-Subtasks. For example, on the Populated Story Map tab, there should be 4 rows for story 1.
Solved by V. H. in 27 mins