Hello, this is the formula; =(C7*100)/C4&"Kar" and the cell shows; 11.3374168521274Kar, I want to preview it like this; 11.33 Kar or 11.34 Kar , with a gap. How can I do it? Thanks..
Hello, this is the formula; =(C7*100)/C4&"Kar" and the cell shows; 11.3374168521274Kar, I want to preview it like this; 11.33 Kar or 11.34 Kar , with a gap. How can I do it? Thanks..
Try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you very much
You're welcome. Thanks for the rep.
You could also just use this formula in your cell...
=(C7*100)/C4
and then Custom Format the cell using this Type pattern...
0.00" Kar"
That way, should you need to use this number in future calculations, it will usable directly... and at its actually calculated value as opposed to its rounded value.
For my suggestion (you can use a similar approach for TMS's code), change the formula you put in the cell to this...
=IFERROR(C7*100)/C4,"")
Works perfectly, thanks..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks