Thread: using IF & AND in formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 174
Default using IF & AND in formula
Perhaps

=B2+SIGN(A2-B2)*A2


Reply With QuoteReply With Quote