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) 

Popular posts from this blog