Function help between worksheets

[ondagreen]

I have a workbook that I have a two different worksheets, (Properties & Remodel). The cell I'm working on is T5 on the Properties worksheet. When I put a value in cell S5 on the Properties sheet, it calculates a value in the cell T5 which is where I want it. This part of the code works great. What I am trying to get accomplished is if I end up with a value in cell C14 on the Remodel worksheet, it overwrites the value that is already in cell T5 of the Properties worksheet. For some reason the only time the Remodel value shows up correctly in T5 of the properties sheet from C14 on the Remodel sheet is when cell S5 has a value of zero.

Here is the function I cannot get to work correctly.

Please Login or Register  to view this content.

[DGagnon]

looks like you just have the conditions backwards, try this:

=IF(Remodel!C14>0,Remodel!C14+3000,IF(S5>0,E5*13))