Excel If formula not evaluating correctly? -
i have if formula evaluating 2 cells data returned other formulas.
=if(b5>d5,d5,b5)
seems simple enough, right? however, when attempt use it, seems evaluating formulas in cells instead of evaluating values being returned.
i.e.: if b5 returns 414 , d5 returns 416, 416 instead of 414.
what missing here?
in testing, formula worked me. trying display lower number of cells? if so, try this
=min(b5,d5)