Formula Help - Easy for somebody

From: Mike B <Mike.B.1vlfbq@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 19 Sep 2005 02:52:29 +0100

I have three clients that get billed at different rates, here is the
formula I have

=IF(contract=John,(J11*50)*B11),IF(contract=Willey,(J11*20)*B11),IF(contract=Ernst,(J11*500)*B11)

But I only get the rate for John? Can anybody fix this?

Thanks

--
Mike B
.

Follow-Ups:
- Re: Formula Help - Easy for somebody
  - From: Aladin Akyurek

Prev by Date: Re: set up a macro in Excel to color cells when clicked
Next by Date: COUNTIF or SUM function (Multiple criteria) HELP!!
Previous by thread: Re: set up a macro in Excel to color cells when clicked
Next by thread: Re: Formula Help - Easy for somebody
Index(es):
- Date
- Thread

Relevant Pages

Re: Computer Switched Off During System Restore!
... In article, John ... > My grandfather has given me his computer to fix. ... Prev by Date: ...
(microsoft.public.windowsxp.help_and_support)
RE: error messages
... Were you able to fix? ... "JOhn" wrote: ... > message that "the spefified server was found, ... Prev by Date: ...
(microsoft.public.outlook.installation)
RE: Error COOD11CD Big Brother Livestream
... hi my name is john i am having the same problem and i dont no how to fix it ... Prev by Date: ...
(microsoft.public.windowsmedia.player)
RE: skip/delete lines with dup keys
... > Don't fix it if it's not broken. ... Thanks John and Jeff. ... Prev by Date: ...
(perl.beginners)
shadow copy option missing
... ntbackup is no longer there. ... Does anybody know of a fix to get this back or a get around? ... John ... Prev by Date: ...
(microsoft.public.windows.server.general)