Hello All,
I am trying to have a cell do the following logic.
IF cell(P25) is greater than cells Q25:Z25 then 1, if false = 0.
Where is what I have tried with no luck:
=IF(P25>($Q$25,$R$25,$S$25,$T$25,$U$25,$V$25,$W$25,$X$25,$Y$25,$Z$25),1,0)
=IF(P25>(Q25:Z25),1,0)
I keep getting the #VALUE in the cell where I want the formula.
I don't think it can process the range of cells.
Ideas?
Bookmarks