ExcelBanter - IF statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF statement (https://www.excelbanter.com/excel-worksheet-functions/145431-if-statement.html)

Tredown

IF statement

I have the following IF statement =IF(B5="R",TODAY(),"") but would like to
use a range of cells. Not sure of the correct syntac

JE McGimpsey

IF statement

Perhaps

=IF(COUNTIF(B5:B10,"R")0,TODAY(),"")

In article ,
Tredown wrote:

I have the following IF statement =IF(B5="R",TODAY(),"") but would like to
use a range of cells. Not sure of the correct syntac

All times are GMT +1. The time now is 04:19 AM.