If statements

T

Tredown

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
 
V

vezerid

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
Click to expand...

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
 
B

Bob Phillips

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)
 
Top