Need help with "if " Function

[stv928]

I am trying to get the highlighted Labor & Material formulas to work with the "if" function.
On line 5 i am trying to add the Material with G&A,Profit&Tax but if there is Labor then i want to only add half of the G&A,Profit & Tax. I can get some of it to work but my formulas are not working if there is labor valule. I want to do the same for the Labor also.

so for Materal Total = 3500 + 732 = 4233 but if there was a Labor Value i would only want Half of the G&A,Profit,Tax. So same funtion for Labor. I have attached the Work Sheet.

[protonLeah]

O5:

Please Login or Register  to view this content.

if labor > 0 divide by 2, else divide by 1

[stv928]

Ben,
please be patient with me on this I am a little green with some of this. I tried to input this formula and its not working on the highlighted T5 cell or U5 cell. I just get the 314 value.

[Phuocam]

Try this in U5:

=P5+IF(O5=0,Q5,Q5/2)

[stv928]

Ok this seams to work some what. But if there is a 0 Value in the P Column I would like it to put a 0 value in the U Column. This would be the same in the T Column.

[protonLeah]

My mistake, that formula in post #2 was meant for Q5 not O5...
Edit:
I just realized that in columns T & U, you have written your formula wrong:

=IF(,O5=0,O5+Q5/2)

You are missing the logical test condition; i.e., the comma before O5. It should have been:

Please Login or Register  to view this content.

Because you omitted your test condition, your IF's are returning the FALSE value.