| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Struggling for a formula
Mike H wrote:
you might consider this modification to your logic:- =IF(AND(cltage<=18,ptnrage<=18),70.7,IF(AND(OR(clt age18,ptnrage18),cltage-<=60,ptnrage<=60),92.82,IF(AND(OR(cltage60,ptnrag e60),cltage<=65,ptnrage<-=65),181.7,207))) That's great; thanks Mike. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Struggling with IF formula...is it even the right one for me? | New Users to Excel | |||
| Struggling to plot where I want | Charts and Charting in Excel | |||
| Struggling IF value | Excel Discussion (Misc queries) | |||
| Struggling for a solution | Excel Worksheet Functions | |||
| Help, I'm Struggling! | New Users to Excel | |||
![Steve[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
