stuartgb100
Active Member
- Joined
- May 10, 2015
- Messages
- 287
- Office Version
- 2021
- Platform
- Windows
Hi, I'm struggling with this:
The formula needs to be one that will autofill if rows are inserted into the table.
The basic formula for row 6 is:
P6=I6*sum(K6:O6)
The constraints are that:
a) the default value for P6 is "0.00"
b) the formula will only execute when there is a numeric value in I6 AND at least one numeric value in the range K6:O6
c) the formula should round the result to 2 decimal places
Thanks.
EDIT:
Sorry,
Should have said that this formula does not autofill:
=IF(OR(NOT(COUNT(I6))),0,SUM(K6:O6))
The formula needs to be one that will autofill if rows are inserted into the table.
The basic formula for row 6 is:
P6=I6*sum(K6:O6)
The constraints are that:
a) the default value for P6 is "0.00"
b) the formula will only execute when there is a numeric value in I6 AND at least one numeric value in the range K6:O6
c) the formula should round the result to 2 decimal places
Thanks.
EDIT:
Sorry,
Should have said that this formula does not autofill:
=IF(OR(NOT(COUNT(I6))),0,SUM(K6:O6))
Last edited by a moderator: