| View previous topic :: View next topic |
| Author |
Message |
lynnp
Newbie
Joined: 24 Feb 2011
Posts: 2
|
 Posted: Wed Mar 28, 2012 9:08 am Post subject: [Solved] HELP! Nested If Statements |
 |
|
I know I am going to kick myself when I get the answer. Anyway I have this: =IF(AND(E11>80000;E11<=95000);H11*0.27) which works
and this: =IF(AND(E11>95000;E11<=112000);H11*0.32) which of course also works (the only difference is the multiplier)
but I can't seem to string them together to make them work. Any help would be greatly appreciated. Thanks
Last edited by lynnp on Wed Mar 28, 2012 10:23 am; edited 1 time in total |
|
| Back to top |
|
 |
floris_v
Moderator
Joined: 12 Jul 2007
Posts: 4605
Location: Netherlands
|
| Posted: Wed Mar 28, 2012 9:25 am Post subject: |
|
|
=IF(AND(E11>80000;E11<=95000);H11*0.27;IF(AND(E11>95000;E11<=112000);H11*0.32;"neither"))
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum |
|
| Back to top |
|
|
lynnp
Newbie
Joined: 24 Feb 2011
Posts: 2
|
| Posted: Wed Mar 28, 2012 10:18 am Post subject: |
|
|
| Thanks much! |
|
| Back to top |
|
|
|
