Thread: A UNIQUE FORMULA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FLATRATE FLATRATE is offline
external usenet poster
  
Posts: 3
Default A UNIQUE FORMULA
Thanks Dave! It worked.

"Dave" wrote:

Oops:
Should be:
=IF(A22,(A1-1)*B2,B2)


"Dave" wrote:

Hi,
If your $4000 is in B2, and number of employees in A2:
=IF(A22,(A1-2)*B2,B2)
Change the ref's to suit your data.
Fegards - Dave.
Reply With QuoteReply With Quote