Posts by 3ball

Re: Error when using solver/goal seek add in

Solved

Re: IF AND OR statement

=IF(OR(AND(D9>=5),AND(B9>=5%,C9>=8%)),"Invest","Do not invest")

Think I got it.. I suppose the AND needs to be nested in the OR not vica versa?

Re: IF AND OR statement

Thanks,

Sorry if I didn't make it clear, however, I need to use the AND OR statement because either B > 5% AND C > 8% OR D > 5.

Hi,

I have a small table that looks as followed;

[ATTACH=CONFIG]71866[/ATTACH]


I am trying to have the invest or do not invest auto populate, the factors are; B > 5% and C > 8% or D > 5

I am using the following formula;

=IF(AND(OR(B7>=5%,C7>=8%),OR(D7>=5)),"Invest","Do not invest")

It works for some of the rows but not all of them?

For example rows 7 and 9 should be "invest" as they meet the above criteria..

Hi, not sure if I am missing something simple here, given up so thought i'd ask.

I am trying to use the solver add in to tell me the unit selling price required in order to get a net profit after tax of 10% of total sales revenue, it's simple accounting stuff, but I get this error when trying to use the goal seek or solver...
[ATTACH=CONFIG]71836[/ATTACH]

[ATTACH=CONFIG]71837[/ATTACH]

"Your entry cannot be used. An integer or decimal may be required."