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

$3.20

175g

$1.82857142857143/100g

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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