surveyorkyle
New Member
- Joined
- Feb 7, 2011
- Messages
- 6
hi all,
I'm trying to use a formula to make an auto populated sentence by pulling information from different cells.
I need the formula to return a "C-"(B12-E12)"RG"(B12), IF (b12-e12) is a negative number or a "F+" if (b1-e12) is a positive number.
b12=700
e12=695.5
sentence would= "C-4.5 RG (695.5)"
I've been trying to get this for awhile now but haven't had any luck. Any help would be appreciated.
Thanks,
Kyle
I'm trying to use a formula to make an auto populated sentence by pulling information from different cells.
I need the formula to return a "C-"(B12-E12)"RG"(B12), IF (b12-e12) is a negative number or a "F+" if (b1-e12) is a positive number.
b12=700
e12=695.5
sentence would= "C-4.5 RG (695.5)"
I've been trying to get this for awhile now but haven't had any luck. Any help would be appreciated.
Thanks,
Kyle