sort of simple if/then

[erutherford]

I have a valve(number) in H15. If that value = "4", then I would like to auto fill cell C15 with "ok" . I was trying to put the formula in another cell (J15) so if a "4" is not entered I can enter a custom description in C15. Clear as mud?

 

[etaf]

you will need VBA to add a function in C15
=IF( H15=4,"OK"O,"")
and then be able to overright with a custom text as that will overwrite the function

I dont provide VBA solutions here

ALSO "4" is text and will not be seen as a NUMBER

 

[erutherford]

you will need VBA to add a function in C15
=IF( H15=4,"OK"O,"")
and then be able to overright with a custom text as that will overwrite the function

I dont provide VBA solutions here

ALSO "4" is text and will not be seen as a NUMBER

thank you for the quick reply. I was trying to avoid VBA just to keep it really simple, but I do remember seeing solution using VBA. I'll look again before posting help. Thanks again

 

[etaf]

you are welcome