ExcelBanter - How can I add 2 cells and have a total of at least 50 in excel?

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

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

- - How can I add 2 cells and have a total of at least 50 in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/249760-how-can-i-add-2-cells-have-total-least-50-excel.html)

jstaublein

How can I add 2 cells and have a total of at least 50 in excel?

I am trying to add 2 cells but I need the total to be at least 50.

Eduardo

How can I add 2 cells and have a total of at least 50 in excel?

Hi,

=if(A1+B1<50,50,A1+B1)

"jstaublein" wrote:

I am trying to add 2 cells but I need the total to be at least 50.

T. Valko

How can I add 2 cells and have a total of at least 50 in excel?

One way...

=MAX(50,A1+B1)

--
Biff
Microsoft Excel MVP

"jstaublein" wrote in message
...
I am trying to add 2 cells but I need the total to be at least 50.

David Biddulph[_2_]

How can I add 2 cells and have a total of at least 50 in excel?

=MAX(A1+A2,50)
--
David Biddulph

"jstaublein" wrote in message
...
I am trying to add 2 cells but I need the total to be at least 50.

All times are GMT +1. The time now is 06:02 AM.