Thread: A UNIQUE FORMULA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default A UNIQUE FORMULA
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