mercredi 30 mars 2016

Excel offset with if formula

I have been scratching my head trying to work this out, I would be grateful if you can help. The formula below offsets 3 places when it finds “Earnings for Period”. However if that cell is enter or zero “0”, I want it to offset 4 places. Any suggestions?

=OFFSET(INDEX($C$2:$C$100,MATCH("Earnings for Period",$C$2:$C$100,0),1),0,3)

Aucun commentaire:

Enregistrer un commentaire