How to place and X in cell F7

Closed

BWitham5 Posts 3 Registration date Thursday March 22, 2018 Status Member Last seen April 6, 2018 - Updated on Mar 22, 2018 at 04:21 PM
Blocked Profile - Mar 22, 2018 at 02:39 PM

Hello,
I am in excel, I want to be able to place and X in cell F7 and have the time automatically be placed in cell G7. can someon please help me.
Thanks
Bill

How to place and X in cell F7
How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Count if cell contains number - Excel Forum
Cell phone battery reset code - Guide
How to insert screenshot in excel cell - Guide

1 response

Answer 1 / 1

Blocked Profile
Updated on Mar 22, 2018 at 02:47 PM

So which part do you need help with?

If syntax is as follow:

=IF(logic_test,true,false)

So, we could do:

=IF(a1="x","IT IS TRUE")

Time syntax can be WAY SIMPLIFIED with:

TEXT(NOW(),"HH:MM:SS")

So, let us know if you need more help. Understand, the time will change every time the sheet is recalculated!

Similar discussions

help me to add particular cells

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

If cell A1 has text then cell B2 has today's Date

Hello,
I'm trying to find a formula that writes,
If Cell A1 has text or any value, then B2 should show today's date and time.

Can someone help me with this please?

Thanks

Fill adjacent cell with number from text answer

Hello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down box, I would like the adjacent cell to poulate with the number (eg Minor injury = 4) I have to do it for the three blank columns Any help will be much appreciated. Thanks, Mitch.

If a cell contains any text then add a value

I hope someone can help me with this...I've done this before but can't remember how.

I have a list of names (for an attendees list) and I need to show an extended total for each
person and the number of guests they will bring. Here's the layout...

B2 is the person's name
C2 is the number of guests they will bring
D2 is the total for that person (including them)

I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.

Hope that makes sense. Thank you in advance for helping.

Excel function question

Hello,

Which spreadsheet function in Excel will display 6 as the output in the following formula?

=(36)

Similar discussions

Subscribe To Our Newsletter!