Hi All,
First time on the site and apologies if I don't describe well..
I have a table with TWO totals and want to use ONE of them to total up multiplying the day rate.
Table is:
First total - Project Effort per task (This is auto populated) = Cell H55
or
Second total - Project Effort per task (This is manually entered) = Cell K55
The Day Rate = O55
Total = Q55 (£ Sterling)
The formula should Multiple the Day Rate(O55) by either H55 (if populated and greater than 0.0) or K55 (if populated and greater then 0.0)
If we have a figure in Column H (automatic entered) and Column K (manually entered) then show 'ERROR' in Q55.
Anyone help pls?
Thanks all for solving and helping me out
Bookmarks