=IF(A1:A10="t","=NOW","")

Alizakore

New Member
Joined
May 6, 2017
Messages
13
What's wrong with this formula? In row A1:A10 if i write t it gives =NOW but not the FORMULA for showing time. What is the mistake here?
Thanks!
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Alizakore, Good afternon.

Try to use:
Code:
=IF(COUNTIF(A1:A10, "t")>0,NOW(),"")
Remember to format as TIME the cell will receive this formula.

Is that wha tyou want?

I hope it helps.
 
Upvote 0
Alizakore,

What kind off error are appearing?

It's a very simple formula.
 
Last edited:
Upvote 0
Alizakore,

What kind off error are appearing?

It's a very simple formula.

Hi,
I get the following error:

https://imgur.com/a/J9QAa
J9QAa
 
Upvote 0
Alizakore, Good evening.

The error message is clear.

You're typing a formula as text.

Did you used CTRL+C and CTRL+V with the suggested formula here and put it at a cell directly?
It's so simple.

To avoid getting too much time to solve something that is apparently simple, save your spreadsheet on a free website, www.sendspace.com or another and place the download link here.
This will make it easier to check what's going on with your data.
 
Upvote 0
Can you not just place this in B1 and drag down?

Code:
=IF(A1="t",now(),"")
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top