Search results

Works thanks!

Sorry I can't get a grasp on writing basic formulas, I'll upload what I need help with Thanks, Ray

Quick reply! Works! thank you, is there a way to hide the number 150 till the formula's used? Thanks Ray

Hello I'm trying to figure out how to get a number then if the number is less than a number then number Heres what I'm attempting: cell I8 =SUM(G8*H8) **this gets my number, but in the same I8 cell how do I determine if the number is less than 150 then 150 I've been trying to figure it out...

Can I ask you how you came up with the solution so that maybe some of it will stick up stairs? :)

My hero! Thanks alot! Ray

Hello, There's 5 other people that will be using it, some would have trouble copying & pasting It would be nice if it was automatically done for them on the "invoice" sheet I have to modify it further as well Thanks, Ray

Sorry I've tryed and can't seem to grasp how to do it I need to copy format, formulas and user input data and from A6 to I53 from sheet 1 to sheet 2 heres a link to the file I'm trying modify: http://www.muzecraft.com/excel/ Thanks!

Meanwhile I'll try to interpid your coding :)

Hi, I'm altering the labour rates in the example you uploaded but it doesn't change the value of the labour, the labour cell is calculating the material as well? Thanks Ray

I'm sorry I'm not fully understanding how your formula works If I understand correctly it is based on matching text? I have it going backwards as you can see in the file below :)http://www.muzecraft.com/excel/testEstimate5.xlsm Its getting close! Thanks! Ray

So I'm guessing this would be the template minus the formulas 3 questions, How would I direct the word Labour to H4 cell? next question is that with each room that Labour cell (H4) would change, there must be a formula for that? the same question would be for the Material cell D4 which would...

Hi I estimate flooring and I need to estimate and total one room at a time for insurance companys on a single spreadsheet, each room is different and may use more lines or less lines. I made an example of how it needs to look: http://www.muzecraft.com/excel/testEstimate3%20.xlsx It would be...

Ok thanks I'll do that

Thanks! now my big question.. I estimate flooring, I need to estimate for insurance companys one room at a time, How would I get it to summarize seperating labour from product (Pst & Gst) and then sub total it then start the whole procedure again with the next room on the same excel sheet...

Sorry I got it to work :) Thank you

Converting to a table looks like the right way to go, how do I keep the existing =SUM(G2)*(H2), I convert it but it stops adding after I do that Thanks

how do I automatically add a new formatted row when I hit enter to finish the original row here's the row I want duplicate http://www.muzecraft.com/excel/testEstimate%20.xlsx I'll have another question as soon as I understand this one :) Thanks

Hello, I'm trying to figure out how to use the current date automatically only once for a estimate quote sheet I want to make out a quote with a 30 day expiry, right now if I make a quote and save it, reviewing it would change the saved date to the current date. I hope I'm making sense, the...