Adding two columns to determine number of days to pay

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
 
N

Niek Otten

Hi Katherine,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
F

Frank Stone

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.
 
Top