-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
$13.50
-
K
Can someone please help me with the nesting of IF/AND functions?
What I need, is if AB17=yes, then if X17=In-State, $7.50 but if X17=Out-of-State, $13.50. But if AB17 is blank and/or doesn't =yes, then no response. This is what I have so far: =IF(AND(AB17="yes",X17="In-State"),"$7.50","$13.00")- KristenB
- Thread
- $13.50 and function excel if function nested formulas
- Replies: 3
- Forum: Excel Questions
-
L
Add sum of products in a row
<tbody> PAID CHURCH YOUTH SIZES ADULT SIZES Name XS SM MED LRG XLRG SM MED LRG 1x 2X 3X 4X # OF SHIRTS TOTAL DUE $13.50 $13.50 $13.50 $13.50 $13.50 $13.50 $13.50 $13.50 $13.50 $15.50 $17.50 $19.50 Pastor 1...- lachone
- Thread
- $13.50 adult lrg med total
- Replies: 9
- Forum: Excel Questions
-
R
Division Formula & ROUNDING UP
Im running a league and I have x amount of players paying $13.50 a week. I am trying to get a formula set-up for this that ROUNDSUP Example for week #1 the total money collected was $1,374 If I divide that =C9/13.5 by $13.50 it comes up with 101.7777778 Now what I am trying to come up with...- RudeBoy
- Thread
- $13.50 =d9/1350 amount formula players rounding week
- Replies: 4
- Forum: Excel Questions
