Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I am trying to get a cell with date information in it to enable a formula of some other cells to happen, in other words when a date is not entered that particular cell is empty therefore the corresponding formula cells are not enabled. Here is a function that works but only when the referanced cell has either "Pending/Issued/Declined" =IF(E4="Issued",F4*H4,IF(E4="Declined",F4*0,IF(E4= "Pending",0))). I would like this function to result correctly with a date entry in the referanced cell rather then wording. How can I do this? -- Thank you, Trying Hard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |