# formula?

#### jlafontaine

##### New Member
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?

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### MrKowz

##### Well-known Member
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

##### New Member
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

##### Well-known Member
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)

Works Great!!.

Thank you

Replies
11
Views
470
Replies
10
Views
258
Replies
11
Views
388
Replies
6
Views
227
Replies
3
Views
142

Threads
1,190,874
Messages
5,983,341
Members
439,839
Latest member
iblackie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back