Is VoG about!!!

  steviegee 15:31 28 Jun 2007
Locked

You helped me with this formula click here but I need to change it a little to a Gross Margin which I think is 100*(B1-$A1)/$A1)a different way round =(B1-A1)*100/B1 please help!!!!

  VoG II 15:34 28 Jun 2007

=IF(OR(ISBLANK($A1),ISBLANK(B1)),"",100*(B1-$A1)/B1)

should work.

  Totally-braindead 15:37 28 Jun 2007

What would the Excel users do without you VoG™?

  steviegee 15:43 28 Jun 2007

Thanks again VoG!

  Stuartli 15:45 28 Jun 2007

VoG™ Excels....:-)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017