Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

asked on

Underlining part of the value of a cell in Excel

=IF(D64<>"","Discounted Cash Value for the Next "&D64&" Years (from Schedule One)","You must enter a name in B43")

When D64=7, the line appears...

Discounted Cash Value for the Next 7 Years (from Schedule One)

Can just the 7 or whatever the resulting number be underlined?
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Golden

ASKER

I did not think there would be a precise solution.  Will try the VBA solution but will need more help in understanding how to run that option.  Thanks.