Hello , If i have cell A1+B1=C1

i want to control the value of C1 ,

in other words , if the result of C1 lies between 250 and 1300 then right the value

but if it is less than 250 , write 250 , if it is more than 1300 , write 1300plse assist me

Try this formula in C1: =IF(SUM(A1:B1)<250,250,IF(SUM(A1:B1)>1300,1300,SUM(A1:B1)))

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll