True False
 

I'm trying to set up an arguement to have cell D1
calculate a monthly total of A1, and display the true
value if equal or less than 25000, or "25000" if greater
than 25001.

any ideas?

One way:

=MIN(A1,25000)


In article ,
"Stro" wrote:

I'm trying to set up an arguement to have cell D1
calculate a monthly total of A1, and display the true
value if equal or less than 25000, or "25000" if greater
than 25001.

any ideas?

=IF(A1<=25000,A1,25000)

or

=MIN(A1,25000)

Regards,

Peo Sjoblom


"Stro" wrote:

I'm trying to set up an arguement to have cell D1
calculate a monthly total of A1, and display the true
value if equal or less than 25000, or "25000" if greater
than 25001.

any ideas?

Thanks!
It's been so long since I had to use a true/false
arguement.