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

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

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

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

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

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