Forum Discussion
Custom number formatting help
Hello, I need some help/advice for displaying a value. Im scaling large recipe amounts, and at some point it'll become cumbersome to do '112 tbsps' and I'd prefer it read '7cups' after a thresho...
How about this:
=IF(A1>=32, A1/16 & " cup(s)", A1 & " tbsp")
Hi! I appreciate the help.
Unfortunately this isn't quite what I am looking for. I was hoping a custom Number Format might be applicable. That way the display is masked but the values stay their original units. I've played with things further and I don't think its going to be possible without altering the formula itself. and converting back and forth mathematically similar to what you are getting at. I was just hoping that since the format was able to scale numbers upwards (the #/8 or ?/?) that it'd be able to also be able to divide them and let me convert with a mask.
Ah well, it was worth a shot! Thanks again for the help.