Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can IF and VLOOKUP functions be inserted together?
I am finishing an online tutorial section. I need to write a function to
determine a water bill. I was able to write a VLOOKUP function (using a provided table in the workbook) for three water rate types but I need to insert a function for inserting $0 as the water bill if a) their bill is waived (determined by a yes or no answer in a column) or b) their water usage is <25,000 gallons (determined by the Gallons Used Column info). When I try to mix the formulas the results are wrong so I know I am making a big and dumb error. This is my last attempted formula: =IF([Bill Waived]="yes",0,IF[Gal Used]<25000,VLOOKUPVLOOKUP(B2,Rates,2,FALSE)*G2/1000 Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
$ for VLOOKUP functions | Excel Worksheet Functions | |||
Inserted Columns into VLOOKUP Tables | Excel Discussion (Misc queries) | |||
VLookup Functions | Excel Worksheet Functions | |||
Automatically copy formulas/functions to inserted rows. | Excel Worksheet Functions | |||
VLOOKUP and IF Functions | Excel Worksheet Functions |