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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone