=IF(A2 Not "","MSRP: $ " + A2 ) not working

[MaximumGravity]

Hi all,

I am trying to write a function (maybe I need a macro or VBA code) that will look at the value of a cell, if it is not blank, append the cell to read "MSRP: $" + the value of the cell - hence

 =IF(A2<>"","MSRP: $ " + A2 )

But this isn't working. This is going to be used to mail merge into word. And if there is no MSRP for a given field, we don't want the words MSRP to appear with a blank afterwards.

For any MS Word gurus, if ther eis an easier way to do this from within word, let me know.

Thanks in advance
Russell

PS HTML tags getting interpreted by "<>" in title
This message was edited by MaximumGravity on 2002-08-29 12:21

 

[Aladin Akyurek]

This needs no VBA:

=IF(LEN(A2),"MSRP: $ " & A2,"")

 

[Rylandir]

How about this ...

If A2 contains the value in question, put this formula in B2

=IF(ISBLANK(A2),A2,"MSRP $"&A2))

 

[Cam]

While we're handing out alternatives.
I think this would do the trick also.

=IF(A2="","","MSRP: $ " & A2)