Home 
Search 
Today's Posts 
#1




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 
#2




If Info In Cell Then Formula In Another
Not very sure, but think we could try:
=IF(E4="","",IF(E4="Issued",F4*H4,IF(E4="Declined" ,0,IF(E4="Pending",0)))) Added on a front check for E4 is empty: .. IF(E4="","", and simplified "F4*0" to just a plain zero Or, perhaps just use: =IF(E4="","",IF(E4<"Issued",0,F4*H4)) may suffice Test it out ..  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Trying Hard" wrote in message ... 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 
#3




If Info In Cell Then Formula In Another
Max,
Slight change in cells to: =IF(E4="","",IF(E4<"Issued",0,G4*I4)) I think this is close to working but I am trying to use an entered date (like 1/6/2006 or any date in E4) take the place of the word “Issued” for the same result of G4*I4. The only other word I want to use in this function is “Decline”,0. So I think it would be something like: =IF(E4="","",IF(E4="???",G4*I4,IF(E4=”Decline” ,0))) The question mark part of this argument needs to be replaced with something that would enable a date entry to allow G4*I4. Any help will be greatly appreciated!  Thank you, Trying Hard "Max" wrote: Not very sure, but think we could try: =IF(E4="","",IF(E4="Issued",F4*H4,IF(E4="Declined" ,0,IF(E4="Pending",0)))) Added on a front check for E4 is empty: .. IF(E4="","", and simplified "F4*0" to just a plain zero Or, perhaps just use: =IF(E4="","",IF(E4<"Issued",0,F4*H4)) may suffice Test it out ..  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Trying Hard" wrote in message ... 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 
#4




If Info In Cell Then Formula In Another
Perhaps try:
=IF(E4="","",IF(E4="Declined",0,IF(OR(ISNUMBER(E4) ,E4="Issued"),G4*I4,""))) (Dates are numbers)  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Trying Hard" wrote in message ... Max, Slight change in cells to: =IF(E4="","",IF(E4<"Issued",0,G4*I4)) I think this is close to working but I am trying to use an entered date (like 1/6/2006 or any date in E4) take the place of the word "Issued" for the same result of G4*I4. The only other word I want to use in this function is "Decline",0. So I think it would be something like: =IF(E4="","",IF(E4="???",G4*I4,IF(E4="Decline",0)) ) The question mark part of this argument needs to be replaced with something that would enable a date entry to allow G4*I4. Any help will be greatly appreciated!  Thank you, Trying Hard 
#5




If Info In Cell Then Formula In Another
Max,
Works Great!  Thank you for your help, Trying Hard "Max" wrote: Perhaps try: =IF(E4="","",IF(E4="Declined",0,IF(OR(ISNUMBER(E4) ,E4="Issued"),G4*I4,""))) (Dates are numbers)  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Trying Hard" wrote in message ... Max, Slight change in cells to: =IF(E4="","",IF(E4<"Issued",0,G4*I4)) I think this is close to working but I am trying to use an entered date (like 1/6/2006 or any date in E4) take the place of the word "Issued" for the same result of G4*I4. The only other word I want to use in this function is "Decline",0. So I think it would be something like: =IF(E4="","",IF(E4="???",G4*I4,IF(E4="Decline",0)) ) The question mark part of this argument needs to be replaced with something that would enable a date entry to allow G4*I4. Any help will be greatly appreciated!  Thank you, Trying Hard 
#6




If Info In Cell Then Formula In Another
You're welcome !
Thanks for the feedback ..  Max Singapore http://savefile.com/projects/236895 xdemechanik  "Trying Hard" wrote in message ... Max, Works Great!  Thank you for your help, Trying Hard 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
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 