Can I get Excel to show a range?

[PFS12]

Hello,

If I have 0 in A1, and 100 in A2, can I get cell B1 to show me 0 to 100, or 0-100? If so how?

 

[Joe4]

Use this formula in cell B1:

=A1 & " to " & A2

or

=A1 & "-" & A2

 

[PFS12]

Use this formula in cell B1:

=A1 & " to " & A2

or

=A1 & "-" & A2

Thank you so very much, I figured it was something simple but If you don't know the right things to ask the program the logic in the help doesn't make much sense.

Thanks again!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[PFS12]

You are welcome.
Glad I was able to help!

One more thing, Is there anyway to write that in as a Dollar range? Formatting won't adjust the value to currency or accounting because its not returning a typical number. so B1 should actually read $0-$100

 

[Joe4]

Since the value being returned is a string, you cannot applied formatting to it. Formatting only works on numeric fields (dates included).

But just keep concatenating on the text pieces you want (the "$"), i.e.

="$" & A1 & "-$" & A2

or you could incorporate the use of the TEXT function.

 

[PFS12]

Since the value being returned is a string, you cannot applied formatting to it. Formatting only works on numeric fields (dates included).

But just keep concatenating on the text pieces you want (the "$"), i.e.

="$" & A1 & "-$" & A2

or you could incorporate the use of the TEXT function.

Perfect! thanks Joe.