| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with if statement that calculate minimum figure
I am trying to calualate an if statement which if false returns a figure, but
i want that figure if under a certain amount to return a minimum figure. Eg. If a2 = yes then return $5 if no or unknown then return A4*A5 but with a minimum of $5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate 20% of a total 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) | |||
| minimum a fixed figure when it is lower | New Users to Excel | |||
| Calculate Minimum numbers | Excel Worksheet Functions | |||
Threaded Mode
