Forum Discussion
Using another cell in a formula if filled in
Afternoon,
I am prorating costs, I have a basic formula that uses dates to calculate how many months we charge.
Cost/12* number of months.
The following equation =H2/12*I2
| Year | FName | SName | BID | Mode | Registration Date | Year End | Annual Fees | ProRata Sum | Pro Rata Fees | Scholarship | Writing Up | Int Discount | RTFD | WD | WD SUM | WDSUM2 |
| 1 | T | TEST | 11231 | FT | 01/09/2017 | 01/07/2018 | £4,195.00 | 10 | £3,495.83 | 03/11/2017 | 2 | |||||
| 2 | 01/09/2017 | 01/05/2018 | £4,195.00 | 8 | £2,796.67 | |||||||||||
| 3 | 01/09/2017 | 01/02/2018 | £4,195.00 | 5 | £1,747.92 |
If however, the data in the column P is entered. I would like this info to be used instead of column L.
Therefore I would like a working equation along the line of this.
=H2/12*I2 OR (H2/12*P2) If P2 is not empty.
I would like the P2 cell to supersede the L2 cell.
I have rattled my brain over this!
Help appreciated.
Chris
1 Reply
Maybe try something like this:
=IF(ISBLANK(P2)=TRUE,H2/12*I2,(H2/12*P2))
