KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
In Excel, I would like to round to the nearest fibonacci number. I tried something like (sorry with a french Excel): RECHERCHEH(C7;FIBO;1;VRAI) -- HLOOKUP(C7, FIBO, 1, TRUE) where FIBO is a named range (0; 0,5; 1;2;3;5;8;etc.) my problem is that this function rounds to the smallest number and not the nearest. For example 12.8 is rounded to 8 and not 13. Note: I just want to use an excel formula, and no VBA
Tags (comma-separated)
Save Edits
Cancel