# Newbie! Help with a formula

1. ## Newbie! Help with a formula

Ok, These are the three formula's. How do I combine them or can I.

=IF((B2="GOV"),[@[Gal Billed]]/1000*1.5)
=IF((B2="NPROFIT"),[@[Gal Billed]]/1000*2,0)
=IF((B2="COM"),[@[Gal Billed]]/1000*3)

2. ## Re: Newbie! Help with a formula

you could try something like this…
=IF(B2="GOV",[@[Gal Billed]]/1000*1.5,IF(B2="NPROFIT",[@[Gal Billed]]/1000*2,IF(B2="COM",[@[Gal Billed]]/1000*3,"")))

3. ## Re: Newbie! Help with a formula

Originally Posted by Sambo kid
you could try something like this…
=IF(B2="GOV",[@[Gal Billed]]/1000*1.5,IF(B2="NPROFIT",[@[Gal Billed]]/1000*2,IF(B2="COM",[@[Gal Billed]]/1000*3,"")))
Thanks, I will give it a try.

4. ## Re: Newbie! Help with a formula

Originally Posted by Sambo kid
you could try something like this…
=IF(B2="GOV",[@[Gal Billed]]/1000*1.5,IF(B2="NPROFIT",[@[Gal Billed]]/1000*2,IF(B2="COM",[@[Gal Billed]]/1000*3,"")))
You are awesome! Thanks again.

5. ## Re: Newbie! Help with a formula

you're welcome. BTW, you had this /1000*2,0) in one of the statements, if you want an alternative output instead of a blank change this /1000*3,""))) to this /1000*3,0))) and it will return a zero instead. If you issue is solved don't forget to mark your post as solved using the thread tools at the top and since you're new to the forum you can say thank you by clicking on the "* Add reputation" part at the bottom of the person's post as that is how we advance in this forum.

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