As IF, I just can't get it right. If need to Add and Divide in the Formula

[cwag1]

I'm trying to design a spread sheet I will also uses as a display. I am wanting to add the row, but if the cell under if says "Half" I want it to divide the number above by 2 then add it. So in my picture B4 is 1 but since B5 says Half I want it to add as .5 will C4 still adds as 2 in U4. So U4 should read 2.5 instead of 1.5. Then something weird I have never seen are all these 3 appearing in Columns V through AL. Thank you in advance for the help.

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Then something weird I have never seen are all these 3 appearing in Columns V through AL.

That is because you are using an array formula & it's Spilling across the row.

 

[Fluff]

How about

=SUM(B4:S4/(1+(B5:S5="half")))

 

[cwag1]

How about

=SUM(B4:S4/(1+(B5:S5="half")))

Thank you that worked great!!, and Account Updated!!

 

[Fluff]

You're welcome & thanks for the feedback.

Thanks also for updating your profile.