Thread: Need Help With using a Sum, If statement with multiple cells

Hi there

I will try to make this as clear as possible, since it is a little convoluted :-)

If I enter a solid number into a cell as in 4 or 4.0, then it needs to be multiplied by 4 (4*4), but if the number ends in a .5 as in 1.5, 4.5, etc...Then the first whole number needs to be multiplied by 4 and then add 2.5 to it...

Example: if it is 4.5, then the 4 would be multiplied by 4, (4*4) and then the .5 would add 2.50 to the 4*4, so the ending result would be (4*4 + 2.50=$18.50)...Clear as mud??

Thanks so much for any help you can provide!!

Assume your number is in A1, then the formula would be:

=IF(A1=INT(A1),A1*4,INT(A1)*4+2.5)

Alan

Hi out there

Trying to use a sum, if statement to sum across multiple cells and am getting an error.

This is what I have:
=SUM(IF(C9:X9=INT(C9:X9), C9:X9*4,INT(C9:X9)*4+2.5))

Thanks for any help!!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST