True False

Stro · Dec 13, 2004

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?

JE McGimpsey · Dec 13, 2004

One way:

=MIN(A1,25000)

Peo Sjoblom · Dec 13, 2004

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

or

=MIN(A1,25000)

Regards,

Peo Sjoblom

Guest · Dec 13, 2004

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

True False

Stro

JE McGimpsey

Peo Sjoblom

Guest