• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula and text

A

arif

Member
Sirs

I want to write a formula in a cell and if that formula in that cell is not applicable then same text in the concerned cell must be retained same

Plz find the attached file and do needful

my all respected sirs
 

Attachments

Hi Airf,

If it is a matter of specific text you can use:
=IF(G7>0,G7,"anmol")

If not, you will need helper cells.

Regards,
 
You must log in or register to reply here.
Back
Top