Hello all,
I am really stuck on this certain formula that I am trying to build. I am using a =IF statement
I need (if D6=B6), True= E6-C6, and False= D6-B6
I have the current IF Statement:THIS IS THE CORRECT FORMULA, but I need= if True to have: number format cells set to h:mm:ss, and if False I need a whole number (for example= 4)
=IF(D6=B6, E6-C6, D6-B6)
I was thinking of doing a =text formula inside the IF, but I am just confused and would be grateful for any help.
Last edited by Tgbell; 06-26-2019 at 02:42 PM.
Tgbell- you can use conditional formatting to accomplish this task. If you post a sample spreadsheet I can go in and do it for you so you can see!
In that case you will need to use conditional formatting. The cell containing this formula would have the General (default) format. You would create a rule with a formula
=D6=B6
Then the format you apply would be Number, Time, h:mm:ss
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
HI,
try this
Formula:
=IF(D6=B6,TEXT(E6-C6,"hh:mm:ss"),D6-B6)
Thank You, I kept inserting it right after I posted and the I kept forgetting the parenthesis. Thanks for the help
What would be an easy way to autofill this formula to the last cell in a vba?
Last edited by Tgbell; 06-26-2019 at 02:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks