two formula's in the same cell
I have a daily hire item in F5 at $10 when its on hire H5 (1) needs to be
paid at 100% ie $10. when it is not on hire (0) it must be discounted by
25% Calculation
what is the formula for this, when I place them in single cells it works
to the following formula in cell i5 =IF(H5=1,F5*100%) answer is 10 and
=IF(H5=0,F5*75%) answer is 7.5
both are correct
how do I get both calcs in the same cell to distinguish between 0 and 1 in
cell H5 so when I fill in and write either 0 or 1 into cell H5 it enters
the correct calculation into I5.
No comments:
Post a Comment