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
...
Maybe try something like this:
=IF(ISBLANK(P2)=TRUE,H2/12*I2,(H2/12*P2))