Nested Formula - HELP
Hi Gayla,
=IF(AND($I$5="",$J$5="",OR(SUM(IF($G$5:$J$5=K3,1)) =1,SUM(IF($G$5:$J$5<=K2,1))=1)),1,"")
on edit mode : press C-S-E.
Note when all referred cells are blank , result is 1.
regards,
driller
--
*****
birds of the same feather flock together..
"Gayla" wrote:
Here are the formulas I am trying to put together into one formula but cannot
seem to get it right.
IF((AND($I$5="",$J$5="") IF TRUE THEN DO THE FOLLOWING CALCULATION:
SEE IF ONE OF THE FOLLOWING APPLY:
OR($G$5=K3,$G$5<=K2),1,""), OR($H$5=K3,$H$5<=K2),1,"")
IF FALSE DO THE FOLLOWING:
SEE IF ONE OF THE FOLLOWING APPLY:
OR($I$5=T3,$I$5<=K2),1,""), OR($J$5=K3,$J$5<=K2),1,"")
Any help will be appreciated.
|