Calculate camping fee

[Mel B]

I have spent a very lot of time on this spread sheet and this newbie is definately in over his head. Lets please try this again.

Column U = Camping Fee/Day
Column V = Utility Fee/Day
Column W = Number of Days of stay
Column X = Calculated Cost of Stay. Represented by formula =(U10+V10)*W10

There are times in an unattended campground when the host does not make contact with the camper before they depart, that the camper mis-calculates the fee for staying in the campground and leaves a different amount of money than the calculated cost. I would like to manually input this dollar value into cell Y10 and at the same time I would like the calculated fee in cell X10 to be $0.00. By doing this I can then sum both columns X and Y to obtain total revenue collected.

The following formula has been suggested as a solution but it is beyond my understanding at this time.

=if(ActVal<>,"",ActVal,=(U10+V10)*W10))

Thanks for your help.

Mel

[Andrew-R]

Change your formula in X10 to:

=IF(Y10<>"","",(U10+V10)*W10)