Results 1 to 4 of 4

Formula problem

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula problem

    I am looking for a way to make my formula calculate after 28 days.
    It for rental rates I have it up to 28 days but if I go past that the cell refers to False.
    What I want to calculate is as followed"
    The rates are day/week/month with a 4 day week and 3 week month
    Can any one help?

    =IF($O21<4,$Q21*$O21,IF($O21<7,R21,IF($O21<11,+R21+(($O21-7)*Q21),IF($O21<14,$R21*2,IF($O21<18,($R21*2)+(($O21-14)*$Q21),$S21)))))
    Last edited by Rod1979; 02-08-2011 at 06:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1