Hi
=IF(M8=O8,Q8+N8-1,Q8+N8)

or shorter:
=Q8+N8-(M8=O8)

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im
Newsbeitrag ...
When I put in the formulat =IF(M8=O8,Q8+N8-1) I get the
column to subtract on for the duplication - however it is
not simply adding my colums q8 and N8 if they do not
equal - can you help me - what is wrong with this
formula?? HELP - Thanks Katherine