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)
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)
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,"")))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
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)
Bookmarks