Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
=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? |
#4
|
|||
|
|||
Thanks!
It's been so long since I had to use a true/false arguement. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
True or False Formula? | New Users to Excel | |||
Problem with Query | Links and Linking in Excel | |||
Paste Special in a macro | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Nexsted if across 3 columns | Excel Worksheet Functions |