View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anders S[_2_] Anders S[_2_] is offline
external usenet poster
 
Posts: 57
Default Code to insert text

Enter in D1

=IF(C11,"Inc","")

Then fill down.

HTH
Anders Silven

"gav meredith" skrev i meddelandet ...
Hi all,

I am after a code that inserts the text 'Inc' into a cell if the cell next
to it is greater than 1. ie: if C11 then D1 should read 'Inc'. I am in
urgent need of this so any help is appreciated!!!

cheers!!!