Thread: Two Formulas in one cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
  
Posts: 615
Default Two Formulas in one cell
My goal is to have a cell that if a person enters 1500 or higher it uses this
formual: =(J19-N19)*50%*E19*65% and if they enter less then 1500 it uses this
formula =(J19-N19)*50%*E19 does anyone know if this is possible?
Reply With QuoteReply With Quote