Hi
I'm using several formalas to build a uinit pricing value, which calculates the price per "£" if greater than £1, or in pence if lower, ie.
43.8p/100g and £1.53/lt
The formula i'm using is below,
=IF(BQ13<1,ROUNDDOWN(BQ13*100,1) & "p/" & $BI13, "£"&ROUNDDOWN(BQ13/100,2) &"/"&$BI13)
The difficulty i'm facing is that if its £1.70 the formula calculates it as £1.7/L,
any ideas on how i can get this back to £1.70/L
I've tried a left concatanate but can't seem to get it working
any help great appreciated!
Adi
Bookmarks