Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Kieran Ewart
Kieran Ewart asked in Computers & InternetSoftware · 6 years ago

Putting a limit on possible ouput numbers in excel?

Update:

So the issue I am calculating a range of potential probabilities of something. I am getting values above 1 every so often and I want to make it so if those values are above 1, they =1. Ive tried using IF statements, however ive found that if its not above 1, it outputs as 0?

2 Answers

Relevance
  • ?
    Lv 6
    6 years ago

    An alternative formula for B1:

    =MIN(A1,1)

  • Seabee
    6 years ago

    Value in A1:A20 (say)...

    In B1, enter: =IF(A1>1,1,A1)

    Copy down as required.

Still have questions? Get your answers by asking now.