| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add condition to =MAX formula
=MAX(0,((U$1-$K4)/7))*R4-T4
I'm using the formula above, which I need to add a condition to, but I'm not sure how. If cell D4 = "On Board", then I want to the formula above to continue, if anything else is in D4, I want the cell to appear blank. Thanks :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add condition to =MAX formula
Have you tried
=if(d4<"on board","",MAX(0,((U$1-$K4)/7))*R4-T4) -- Don Guillett Microsoft MVP Excel SalesAid Software "KC" wrote in message ... =MAX(0,((U$1-$K4)/7))*R4-T4 I'm using the formula above, which I need to add a condition to, but I'm not sure how. If cell D4 = "On Board", then I want to the formula above to continue, if anything else is in D4, I want the cell to appear blank. Thanks :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add condition to =MAX formula
=IF(D4="On Board",MAX(0,((U$1-$K4)/7))*R4-T4,"")
-- David Biddulph KC wrote: =MAX(0,((U$1-$K4)/7))*R4-T4 I'm using the formula above, which I need to add a condition to, but I'm not sure how. If cell D4 = "On Board", then I want to the formula above to continue, if anything else is in D4, I want the cell to appear blank. Thanks :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add condition to =MAX formula
Hi,
=IF(D4="On Board",MAX(0,((U$1-$K4)/7))*R4-T4,"") Mike "KC" wrote: =MAX(0,((U$1-$K4)/7))*R4-T4 I'm using the formula above, which I need to add a condition to, but I'm not sure how. If cell D4 = "On Board", then I want to the formula above to continue, if anything else is in D4, I want the cell to appear blank. Thanks :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula until condition met | Excel Worksheet Functions | |||
| Formula until condition met | Excel Worksheet Functions | |||
| Please Help Again-Condition Formula | Excel Worksheet Functions | |||
| Add Condition to Formula | Excel Discussion (Misc queries) | |||
| Formula For If & Or Condition | Excel Discussion (Misc queries) | |||
Linear Mode
