How would I combine all these functions into a single cell A3:
A1 3.08
A2 .17
A3 = A1+A1*A2
and then ROUND that result to 2 decimal places and add > (greater than or equal to) before that value, and after add "°".
The result being >3.60°
TIA
How would I combine all these functions into a single cell A3:
A1 3.08
A2 .17
A3 = A1+A1*A2
and then ROUND that result to 2 decimal places and add > (greater than or equal to) before that value, and after add "°".
The result being >3.60°
TIA
Got it using Windows character map.
In A3..
=">" & ROUND(A1+A2*A2,2) & "°"
Hope that helps..
Mohit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks