+ Reply to Thread
Results 1 to 3 of 3

Not less than formula?

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    California USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Not less than formula?

    Below is my formula, basically taking the 10Year Bond price from a data point adding a Margin resulting in an end rate, but I want to add a floor or a not less than function to ensure we don’t drop the formula rate below 4.0%

    =ROUND('Data Sheet & 10 Year Update'!B20/(1/8)%,0)*(1/8)%

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: Not less than formula?

    didnt check the formula, but provided that it is right yo can embed it in MAX function:
    =MAX(4%,ROUND('Data Sheet & 10 Year Update'!B20/(1/8)%,0)*(1/8)%)
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    02-27-2014
    Location
    California USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Not less than formula?

    Thank You!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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