Hi Saadia
Try
=IF(and(F20<"",L20="",H20=""),G20,0)
I think you made a mistake in your logic. You said So if there is a date
in F20 and no date in L20 and no date H20 then 0
otherwise G20 but maybe you meant So if there is a date in F20 and no
date in L20 and no date H20 then G20
otherwise 0
Just guessing, try it
Regards
John


"Saadia" wrote in message
...
Hi,
Thanks for your reply.
I tried it out, but doesn't seem to work for some reason.
On jobs that are approved it's resulting in a zero and the remaining ones
it's giving me the estimate amount. I double checked my cells and the
order
of the true and false values and it all looks correct.
the date cells are formated as dates...
Any ideas?

"Sheeloo" wrote:

Try
=IF(and(F20<"",L20="",H20=""),0,G20)

"" has two " with nothing in between the pair



"Saadia" wrote:

Hi,
I am trying to setup an if statement to calculate the $ amount for all
jobs
approved but not yet started.

i need to know how to write ex: "if A3 has a date then calculate the
formula" into the "if statement".

Column F= Date Approved
Column G= Estimate Amount
Column L = Invoice date
Column H = Date Started

So if there is a date in F20 and no date in L20 and no date H20 then 0
otherwise G20
So far i have =if(and(L20=" ",H20=" ",f20=DATE???),G20,0)
I get lost at the date part...hopefully i'm on the right track..

*The reason i have included date started is because i have to setup a
different formula for jobs that have been started and not yet approved.
Any help would be appreciated.
Thanks :)