View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trying Hard
 
Posts: n/a
Default If Info In Cell Then Formula In Another

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