Help with formula

D

Diogie

I need help with a formula based on the following:

B1 = 4.25
B2 = 5.25
B3 = 8.00
B4 = 12


B8 = 2 or 3
E10 = any number
G10 = any number
K10 will equal either hourly, B&B, or will be left blank

If B8=3 and K10 is blank, then H10 needs to equal B1*G10.
If B8=2, and K10 is blank, then H10 needs to equal B2*G10.
If K10=hourly, then H10 and I10 both need to equal 0 and J10 needs to equal
E10*B3
If K10=B&B, then H10 and J10 both need to equal 0 and I10 needs to equal
E10*B4


I think I'm getting part of the formula, but I don't know how to get it to
look at B8. Here's what I have but it doesn't work right.

=IF(K10="B&B","0",IF(K10="hourly","0",IF(K10=" ",IF(B8=3,G10*B4,G10*B3))))

Can anyone help? Thanks in advance!!
 
S

Simon Lloyd

This should get you stated with your formula structure, this would be
the formula for H10:
=IF(AND(OR(B8=2,B8=3),K10=""),B1*G10,IF(OR(K10="Hourly",K10="B&B"),0,""))

Diogie;296161 said:
I need help with a formula based on the following:

B1 = 4.25
B2 = 5.25
B3 = 8.00
B4 = 12


B8 = 2 or 3
E10 = any number
G10 = any number
K10 will equal either hourly, B&B, or will be left blank

If B8=3 and K10 is blank, then H10 needs to equal B1*G10.
If B8=2, and K10 is blank, then H10 needs to equal B2*G10.
If K10=hourly, then H10 and I10 both need to equal 0 and J10 needs to
equal
E10*B3
If K10=B&B, then H10 and J10 both need to equal 0 and I10 needs to
equal
E10*B4


I think I'm getting part of the formula, but I don't know how to get it
to
look at B8. Here's what I have but it doesn't work right.

=IF(K10="B&B","0",IF(K10="hourly","0",IF(K10="
",IF(B8=3,G10*B4,G10*B3))))

Can anyone help? Thanks in advance!!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
D

Diogie

Worked great!!! Thanks so much!!!
--
Diogie


Simon Lloyd said:
This should get you stated with your formula structure, this would be
the formula for H10:
=IF(AND(OR(B8=2,B8=3),K10=""),B1*G10,IF(OR(K10="Hourly",K10="B&B"),0,""))




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
D

Diogie

I spoke too soon. This works with the number 3 in B8, but nothing changes
when I change the 3 to 2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top