|
Help with formula
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!! -- Diogie |
Help with formula
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="Ho urly",K10="B&B"),0,"")) Diogie;296161 Wrote: 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!! -- Diogie -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82781 |
Help with formula
Worked great!!! Thanks so much!!!
-- Diogie "Simon Lloyd" wrote: 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="Ho urly",K10="B&B"),0,"")) Diogie;296161 Wrote: 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!! -- Diogie -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82781 |
Help with formula
I spoke too soon. This works with the number 3 in B8, but nothing changes
when I change the 3 to 2. "Diogie" wrote: Worked great!!! Thanks so much!!! -- Diogie "Simon Lloyd" wrote: 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="Ho urly",K10="B&B"),0,"")) Diogie;296161 Wrote: 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!! -- Diogie -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82781 |
| All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com