I have the following if statement, =IF(B5="B",TODAY(),"") but i would like to
use a range of cells, Not sure onthe correct sytact

On Jun 6, 2:22 pm, Tredown wrote:
I have the following if statement, =IF(B5="B",TODAY(),"") but i would like to
use a range of cells, Not sure onthe correct sytact

Not sure of what you want either. You want TODAY() in a single cell if
any of B1:B20 are equal to "B"? You want to apply this formula to many
cells at once and fill several with TODAY() or ""?

Please be more specific as to your intentions and structure of data.

HTH
Kostis Vezerides

Maybe you mean

=IF(OR(B5="B",C2="B",D9="B"),TODAY(),"")

just extend as wanted.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tredown" wrote in message
...
I have the following if statement, =IF(B5="B",TODAY(),"") but i would like
to
use a range of cells, Not sure onthe correct sytact