IF Sum Question

[bloodmilksky]

Hi Guys,

I was just wondering if anyone knew what the sum was for

=E2(IF("",NA,(TODAY()))

I have tried entering it as an array but doesnt seem to work.

Basically I just want it so if there is a text value in E2 return todays date in C2 if not it will return NA

 

[KasperKL]

You need this:

=IF(ISTEXT(E2)=TRUE,TODAY(),"N/A")

Remember to format your cell as 'Date'

You don't need to enter it as an array formula

 

[BarryL]

=if(e2="","na",today())

 

[AliGW]

No need for an array formula, just the correct syntax! In C2:

=IF(E2="","NA",TODAY())

 

[BarryL]

You need this:

=IF(ISTEXT(E2)=TRUE,TODAY(),"N/A")

Remember to format your cell as 'Date'

You don't need to enter it as an array formula

or

IF(ISTEXT(E2),TODAY(),"N/A")

 

[bloodmilksky]

Thank you soooo Much really appreciate your help.

can I just ask if I wanted a similar formula but simply created a line number ever time a text value was in E2 would that be a similar formula? so Like 1,2,3,4,5 and so on

 

[AliGW]

Thank you soooo Much really appreciate your help.

can I just ask if I wanted a similar formula but simply created a line number ever time a text value was in E2 would that be a similar formula? so Like 1,2,3,4,5 and so on

Please clarify: what would the expected outcome be? Are you looking for an incremental solution? If so, it's going to be more complex.

 

[bloodmilksky]

I am awfully sorry I am talking pre caffine at the moment so not making much sense.

but yes if there was a text value in E2 the outcome would be incremental so 1,2,3 and if not just NA

 

[MARZIOTULLIO]

Hi

c2=IF(ISTEXT(E2),COUNTIF($E$2:E2,"*"),"N/A")

 

[bloodmilksky]

Thank you So much really appreciate your help