Thread: IF function problem,
View Single Post
  #1   Report Post  
annae annae is offline
Junior Member
  
Posts: 1
Default IF function problem,
I'm trying to calculate a maximum amount of value. That is, if a value is higher than 50000, it needs to display 50000. If not, display current value.

A1=35678
B1 should display 35678 (that is, equal to A1)

A1=67980
B1 should display 50000
Last edited by annae : September 13th 19 at 02:33 PM
Reply With QuoteReply With Quote