Check a cell with a "X" 2

[rampure]

Hi,

This is my first day and first question here.
I am trying to check a cell with a "X" if there is no data in the other cells.

For example - if c5=0 and j5 = 0, then I want Xin B5.

Can someone help me with the steps? I am trying to write a module so it can be done automatically.

Appreciate your responses.

Thanks
Smitha

 

[SkipVought]

Hi,

In B5:
[tt]
=IF(AND(c5=0,j5 = 0),"X","")
[/tt]


Skip,

_[red][/red]

 

[AnotherHiggins]

Howdy, rampure! Welcome to Tek-Tips.

When you say "module" what do you mean? If you want to accomplish this with a macro/VBA, please repost your question in forum707.

for a Formula, you would just put the following in B5:

[tab][COLOR=blue white]=if(and(c5=0,j5 = 0),"X","")[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[rampure]

Thanks Skip and John.

I did the same, but I want to do this with a macro.
I will repost this in the forum John mentioned.

Smitha