Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statements - Novice
Hi i have a problem with this simple IF statement,
what i want is to calculate one amount (90) for 0-3hrs then multiply by (30) So the charge for 1,2 or 3 hours will be £90 but then 4 hours £120, 5 hours £150 etc. What I have so far is: =if(N95<=3,90,N95*30) This works fine except if the total in N95 is 0 it is still showing a charge of £90 which should be £0.00. Any help on this would be great as i haven't used IF statements in ages. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Novice needing help!!! | Excel Worksheet Functions | |||
Please help! Excel Novice here | Excel Worksheet Functions | |||
Novice needs help. | Excel Discussion (Misc queries) | |||
Novice Needs Help with Formulas | Excel Worksheet Functions | |||
Help And Advive For A Novice | Excel Discussion (Misc queries) |