| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate cell value with a minimum to be displayed
I need to calculate an "Admin Allocation" of 5% of revenue but the result
cannot be less than $500.00. Example below- A 1 4500.00 2 Using above cells, A1*0.05 equals 225 in A2 but I since A2 is less than $500 I need to force A2 to be $500. What is the correct formula for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with if statement that calculate minimum figure | Excel Worksheet Functions | |||
| How to calculate non-zero minimum value? | Excel Discussion (Misc queries) | |||
| How to calculate minimum distance between three coordinate with ex | Excel Discussion (Misc queries) | |||
| formula to calculate values displayed in a chart | Excel Discussion (Misc queries) | |||
| Calculate Minimum numbers | Excel Worksheet Functions | |||
Threaded Mode
