View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JV JV is offline
external usenet poster
 
Posts: 22
Default formula using several colums

I need a formula that would subtract 200,000 from a cell and if the result is
a minus, zero would be put in the cell.

I also need a formula that check coulme a, b, c, d and if a could exists it
subtracts an amount from column f

Thanks in advance