| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Formula help
I need to set up a formula that says:
A3 needs to be 30% of A2 unless B4 is less than 30% of A2, Then A3 needs to be = to but not more than B4 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Formula help
Try
=IF(B4<A2*0.3,B4,A2*0.3) -- Lil On Thu, 23 Jul 2009 16:27:01 -0700, Jimog01 wrote: A3 needs to be 30% of A2 unless B4 is less than 30% of A2, Then A3 needs to be = to but not more than B4 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Formula help
"Jimog01" wrote:
I need to set up a formula that says: A3 needs to be 30% of A2 unless B4 is less than 30% of A2, Then A3 needs to be = to but not more than B4 =min(B4,A2*30%) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell formula. | Excel Worksheet Functions | |||
| Excell convert formula row to formula column | Excel Worksheet Functions | |||
| formula - excell | Excel Worksheet Functions | |||
| Excell formula | New Users to Excel | |||
| excell formula 9+5=4 not 14 | Excel Worksheet Functions | |||
Linear Mode
