formula?

[jlafontaine]

I have an estimating template that I use. It would save me a ton of time if I could figure out how to make a value based on another cell.

example: Cell B1 has text as "Labor" I want cell F1 to automatically put $35.00 or B2 has text as "Forman" I want F2 to put $45.00 ..... is this possible?

 

[MrKowz]

Enter this formula into F1, and format F1 accordingly to show the $ and .00

=if(B1="Labor",35,if(B1="Forman",45,""))

Copy the formula down, and the B1 part will automatically change to B2, B3, B4, etc

 

[jlafontaine]

can this be used for several different items? Machinery/materials/vehicals?

Enter this formula into F1, and format F1 accordingly to show the $ and .00

=if(B1="Labor",35,if(B1="Forman",45,""))

Copy the formula down, and the B1 part will automatically change to B2, B3, B4, etc

 

[MrKowz]

Yes, it can be used for up to I think 7 things. However, it is possible to make this easier on yourself by first creating a seperate table somewhere else that lists all of the positions with their pay. This alternate method is much easier to use, and is able to be used for an unlimited amount of data.

For example:

On sheet 2, put all of the positions in column A (we will assume you have 10 positions) and all of the rates in column B.

Then in cell F1 on your sheet1, use the following formula:

=vlookup(B1,sheet2!$A$1:$B$10,2,FALSE)

 

[jlafontaine]

Works Great!!.

Thank you