Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statements
Hi
I'm trying to write this if statement to calulate a minimum charge of £90 for 0-3hrs =IF(N95=0,0,IF(N95<=3,90,N95*30)) however it's calculating £30 per hour instead of charging the minimum charge. I think the problem is that i'm going off monthly totals and should be using a Vlookup to search the columbs for results? I'm unsure how to do this and hopw it would fit with the formula i'm currently using. Any help would be of great assistance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statements
The formula is fine. You simply have to make sure that the hours you want to
change ARE IN cell N95. It CAN be a total. It CAN be a vlookup. BUT it has to be in the cell you're looking at. ie N95. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Joe" wrote: Hi I'm trying to write this if statement to calulate a minimum charge of £90 for 0-3hrs =IF(N95=0,0,IF(N95<=3,90,N95*30)) however it's calculating £30 per hour instead of charging the minimum charge. I think the problem is that i'm going off monthly totals and should be using a Vlookup to search the columbs for results? I'm unsure how to do this and hopw it would fit with the formula i'm currently using. Any help would be of great assistance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statements
Charge not Change.
Sorry. Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the If Statements | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions | |||
Dim statements in VBA | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
More than 7 IF statements | Excel Discussion (Misc queries) |