Jtucker10278
Board Regular
- Joined
- May 14, 2017
- Messages
- 61
I was looking for the formula to only return whole numbers from and equation. TRUNC seemed to fit my needs but I couldn't find any examples of it being used in a formula only as a standalone for converting an existing number.
granted it took me only 1 try to figure it out
=Trunc(A1*B1)
but at that point I was already halfway down the rabbit hole., and now I am curious if there are any stand alone functions in Excel that won't interact with any other Functions.
granted it took me only 1 try to figure it out
=Trunc(A1*B1)
but at that point I was already halfway down the rabbit hole., and now I am curious if there are any stand alone functions in Excel that won't interact with any other Functions.