LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"