What's wrong with this IF function.
In B1 through B7, I have two numbers in the same cell, something like this
B1=$20.44 - 13.00%. I used the "&" to have the two numbers together in the
same cell.
I want to show an arrow on column C where the percentage is the highest. The
results on column B change everyday because I am using the =TODAY().
So how do I get to show an arrow where the percentage is highest?? Something
close to my IF function??
=IF(B1=MAX(RIGHT(B1,6):RIGHT(B7,6)),"","")
"Mike H" wrote:
Hi,
It's not entirely clear what your trying to do but maybe this
=IF(RIGHT(B1,6)+0RIGHT(B7,6)+0,"","")
Mike
"GEM" wrote:
=IF(B1=MAX(RIGHT(B1,6):RIGHT(B7,6)),"","")
|