| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning a value in a cell if condition is met
H4 contains D or N
K4 contains time 00:45 V4 would return value of K4 if H4 = D,otherwise 00:00 Y4 would return value of K4 if H4 = N, otherwise 00:00 have been looking through all the questions and cant find, would greatly appreciate thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning a value in a cell if condition is met
I have just figured it out, for anyone looking I will post the formula,
=IF(H5="N",SUM(K5)," 00:00") "v1rt8" wrote: H4 contains D or N K4 contains time 00:45 V4 would return value of K4 if H4 = D,otherwise 00:00 Y4 would return value of K4 if H4 = N, otherwise 00:00 have been looking through all the questions and cant find, would greatly appreciate thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning a value in a cell if condition is met
Try this.
In cell V4 Paste this formula:- =IF(H4="D",K4,"00:00") In cell Y4 Paste this formula:- =IF(H4="N",K4,"00:00") Format the K4 value as Text and type 00:45 If this post helps, click yes! -------------------- (MS-Exl-Learner) -------------------- "v1rt8" wrote: H4 contains D or N K4 contains time 00:45 V4 would return value of K4 if H4 = D,otherwise 00:00 Y4 would return value of K4 if H4 = N, otherwise 00:00 have been looking through all the questions and cant find, would greatly appreciate thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
returning a value in a cell if condition is met
Thanks for your help, one note, the value in K4 is automated by another cell
and has to be time, not text, however i will try it anyway. thanks again "MS-Exl-Learner" wrote: Try this. In cell V4 Paste this formula:- =IF(H4="D",K4,"00:00") In cell Y4 Paste this formula:- =IF(H4="N",K4,"00:00") Format the K4 value as Text and type 00:45 If this post helps, click yes! -------------------- (MS-Exl-Learner) -------------------- "v1rt8" wrote: H4 contains D or N K4 contains time 00:45 V4 would return value of K4 if H4 = D,otherwise 00:00 Y4 would return value of K4 if H4 = N, otherwise 00:00 have been looking through all the questions and cant find, would greatly appreciate thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop cell showing zero when returning a blank cell | Excel Discussion (Misc queries) | |||
| Returning Cell Contents of One Cell Based On Another Cell | Excel Worksheet Functions | |||
| I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
| how to create a condition returning 2 different drop down lists? | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Linear Mode
