Adding two columns to determine number of days to pay
 

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

Adding two columns to determine number of days to pay
 

Hi Katherine,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Katherine" wrote in message
...
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

Adding two columns to determine number of days to pay
 

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

Adding two columns to determine number of days to pay
 

The only thing "wrong" i see is maybe the formula is
incomplete. =if(M8=O8,Q8+N8-1,"")
I played with the formula in xl2k. if M8 and O8 are not
equal i get a FALSE in the cell. adding the ,"" leaves the
cell blank(looking).You may wish to put another condition
there. "" is basicly saying do nothing. If M8 and O8 are
equal then the formula adds as expected.

-----Original Message-----
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
.