Solved How to contrl excel cell value

October 4, 2017 at 07:27:09
Specs: Windows 8
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 1300

plse assist me


See More: How to contrl excel cell value

Reply ↓  Report •

#1
October 4, 2017 at 08:08:51
✔ Best Answer
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


Reply ↓  Report •
Related Solutions


Ask Question