multi function formula

Copper Contributor

anyone know how i would format a cell to multiply another cell by percentage but if another cell has a number in it that number would need to overwrite the formula.

so d2*1.25 but then if cell e2 has a number then the number being put into cell f2 would be that number instead of the mutiplication

1 Reply

@davdesign150 

Perhaps

=IF(ISNUMBER(E2),E2,D2*1.25)