LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Novice needing help!!! Sarah Excel Worksheet Functions 3 May 27th 07 04:48 PM
Please help! Excel Novice here Theresa[_2_] Excel Worksheet Functions 14 May 15th 07 12:51 PM
Novice needs help. aphwood Excel Discussion (Misc queries) 1 October 4th 05 07:56 PM
Novice Needs Help with Formulas Donna123 Excel Worksheet Functions 1 September 4th 05 03:40 PM
Help And Advive For A Novice Joe Williams Excel Discussion (Misc queries) 1 May 26th 05 03:49 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"