Need help with this formula

[Gqmoose]

Hi all,

MY formula is this
=IF(OR(ISBLANK(E15),ISBLANK(F15)), "", "$" &E15/F15*100 &"/100g")

and my result is this
[TABLE="width: 290"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] $3.20[/TD]
[TD]175g[/TD]
[TD]$1.82857142857143/100g[/TD]
[/TR]
</tbody>[/TABLE]

Issue I'm having is I would like to only have the multiplied number to 2 decimal places but unfortunately can't figure out how.

Thanks for your help.

 

[Yongle]

try this


=IF(OR(ISBLANK(E15),ISBLANK(F15)), "", "$" &TEXT(E15/F15*100,"0.00") &"/100g")

 

[Gqmoose]

Yongle, You're a legend!

Thank you very much as it worked a charm.

 

[Yongle]

Glad it helped