Adding two columns to determine number of days to pay

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

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
 
Hi Katherine,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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.
 
Back
Top