Posted to microsoft.public.excel.misc
|
|
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
|