ExcelBanter - IF formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF formula (https://www.excelbanter.com/excel-discussion-misc-queries/219217-re-if-formula.html)

Gary''s Student

IF formula

=IF((A1+B1)<0,0,MIN((A1+B1),2000))
--
Gary''s Student - gsnu200831

All times are GMT +1. The time now is 02:53 PM.