help writing excel equation if statement into vba

[union]

hi everyone, i'm trying to write this formula excel if equation

=IF(D17="vacant","average of occupied "&C17,"")

into something like ws.Range("I17").Formula

this is driving me nuts. can somebody please help.

thanks

[Olly]

Try:

Please Login or Register  to view this content.

[ajryan88]

Hi,

Try

Please Login or Register  to view this content.

Hope this helps

[union]

thank you very much ajryan88 and ollyxls

[ajryan88]

You're welcome

Please don't forget to mark this thread as solved, and please click on the * next to the posts that were helpful to you