If statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement 1
Combine IF Statments 2
IF function says too many nested 1
SUMIF data that falls within a range 3
Simple nested if and statement 2
Can I combine IF/AND/OR statements? 8
How do you Combine Two IF formulas 4
Checking Dates against Bank Holidays 2

Back
Top