wondered

I need an IF statement that keys off grades of C- to A+. Something like this: IF(B1>="C-",A1,""). I know that statement doesn't work, while using a series of OR statements does, but I wondered if there was something simpler than the OR statement approach which uses 9 substatements, e.g...

Hi All, Just wondered if it was possible to create a button in access using a jpeg ?

I've worked with Excel 2010 for many years and have developed some very large spreadsheets. I find that the files take ages to load and then a long time to recalculate. I wondered if moving to Excel 365 or another newer version would help? Thanks Ray

Hello, Hoping someone might be able to assist please. I am running a program which updates some results if you place -6 in the q2 cell.I have been doing this manually but I wondered if there was a formula I could put in that would place the minus 6 (-6) number in the q2 cell say every 5 seconds...

Morning all, Strange request.. I have seen a graph that is basically a train that moves along when the data changes and wondered if anyone can help me replicate it. Thanks Dan

Hi All, I just wondered if someone could advise on how the follow. I need to be able off the back of a macro for one cell to keep a count of every time a button is pressed. I google sheets i know this is possible with the following function as show below, but wondered if the same could be done...

Good Morning, I have identified the 2 largest numbers in a row using LARGE in a range A1:F1 with the answers in A3 and A4. Then I tried to identify the cell reference for each using using =CELL("address",INDEX($A$1:$F$1,MATCH(A3,$A$1:$F$1,0))) for the 1st and...