How to value cell G6 to be equal the value of A5, only when the value of cell A5 is more than 15?

tesoke · #1 01-12-2016, 11:37 PM

Hi, I have another problem and need help. I hope you help me like always. Thanks a lot.

I want to determine the value of cell G6 to be equal the value of cell A5, only when the value of cell A5 is more than 15. What should for this?

Thanks for any help and bless you all.

Pecoflyer · #2 01-13-2016, 12:29 AM

In G6 enter =IF(A5>15,A5,"")

tesoke · #3 01-13-2016, 01:48 AM

Thank you so much. I have another similar question and hope you help. Thanks.

A5 = 15:00 - 0:20 (if H4 is more than 0:15) + 22 - (D5/2) (if K11 is more than 0:45)

tesoke · #4 01-14-2016, 12:49 PM

no help? I need help. Please help me. Thank you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation,force cell to be filed with number if respective cell is not empty	nicholes	Excel Programming	0	08-01-2015 09:08 AM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Automatically change the value of one cell so that two other cells become equal	matthew544	Excel	5	09-18-2011 08:56 AM
Dividing merge cell into ten equal rectangles for inputing Digit?	aligahk06	Excel	0	05-12-2010 06:56 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM