Fault with defined range

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I am having difficulty getting the following formula accepted,

=if(ccref=ControlCentre!$C77),row(locations)-cell("Row",locations)+1)

it highlights on the numeric figure 1, on the last part of the formula.
Anyone know what could be happening?
Thanks
Pat
 
Pat wrote...
I am having difficulty getting the following formula accepted,

=if(ccref=ControlCentre!$C77),row(locations)
-cell("Row",locations)+1)
Click to expand...
...

You have a stray right parenthesis at the end of the IF function's
condition. The corrected formula is

=IF(ccref=ControlCentre!$C77,ROW(locations)
-CELL("Row",locations)+1)
 
Back
Top