references and text strings

[mzdrea215]

I have an excel assignment due tonight at midnight. I am stuck on this one question before i can move on.

In cell D3, enter a reference to the value in B7. Format the cell to display the text string Interest Rate.

In D3 i entered =B7 and the value for B7 popped up in cell D3, I am confused on how to enter the text string. Anyone have any ideas on how to complete this??

 

[S.H.A.D.O.]

Do you mean something like this???

=IF(B7>"","Interest Rate","")

I hope this helps!

 

[mzdrea215]

If a value does not appear in D3 does that mean it worked??

Do you mean something like this???

=IF(B7>"","Interest Rate","")

I hope this helps!

 

[mikerickson]

You might look at Custom Number Format to see how to have the value in D3 be the same as in B7 while always displaying the string "Interest Rate".

 

[S.H.A.D.O.]

If a value does not appear in D3 does that mean it worked??

It basically means that if cell B7 is BLANK then it will put a BLANK (""), otherwise if cell B7 is greater than BLANK then it will put the string "Interest Rate".
If you leave out the "" it will return FALSE.
Try it for yourself and see!

You could also try Mike's suggestion above which is nice.

I hope this helps.