# How do I use If in a calculations?

1. ## How do I use If in a calculations?

I created a simple spreadsheet for an occasional helper.
Column B is # of hours
Column C is the Yes/No for Jobsite
Column O is the hourly rate.

If he helps me around the house, he gets an hourly rate defined in column O.
If he comes with me to a Jobsite, he gets an extra 2 dollars an hour.

I thought this would do it, but obviously it's not working:
=IF(C19="Yes",(B19*(O19+2))), (B19*O19)

Thank you in advance.

2. ## Re: How do I use If in a calculations?

Try:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: How do I use If in a calculations?

Originally Posted by TMS
Try:
Formula:
`Please Login or Register  to view this content.`
That worked.

Thank you!

4. ## Re: How do I use If in a calculations?

You're welcome. Thanks for the rep.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1