| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Formula troubles
I need to do the following calculation:
((1-((1-AE5)*10))*V14) but only when: ((1-((1-AE5)*10))*V14)=0 or <=V14*1.5 If greater than or = to V14*1.5 then =V14*1.5 And if less than or = 0 then =0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Formula troubles | Excel Worksheet Functions | |||
| Formula troubles | Excel Discussion (Misc queries) | |||
| Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
| Advanced Formula... | Excel Discussion (Misc queries) | |||
| Formula Troubles........ | Excel Worksheet Functions | |||
Threaded Mode
