Search results

I'm thinking the DGET formula could be used, but how would I get it to link to the file name I enter (e.g typing in Sage Code: '123456' would ask me if I want to view the '123456' jpeg image), then open it if YES?

I make static caravans. I'm looking to create an information hub and would like some feedback on the best way to do this with formulas please? This is my menu: The plan When a Sage code (6-digit part code) is typed in as shown above, I would like it to offer the option 'View Photo?'. The...

Hi Peter. Just a quick note to say thank you, I'm not ignoring you. I've been off for a couple of days and need to catch up on a few things. There's things not quite right with the data (my end). I will get back as soon as possible.

Many Thanks Peter. I have amended my graph as a scatter and added the trendline with the POWER option. I have also inverted the axis, as the radiator output is my unknown values (apart from the examples I have provided in the table). So my chart now looks like this: I have simplified the...

I am trying to create a simple calculator in Excel from a set of variable data figures I have, but I am stuck on the equation even before I've got to the Excel coding. Below are the two data entry "calculator" displays I would like to use. I would enter the Home U-Value and the Floor Area from...