Sep 24 2024 04:12 AM
Hi
I am trying to make an 'IF' function. I have a set of data & prices - I would like it to automatically fill a column. So if anything in column D is 1, E will be 0.86, if D is 2, it would be 1.72 etc.
TIA
Sep 24 2024 05:50 AM
Unless there's more context to your data than the sample provided, I think the simplest way to do it is:
=D1:D10*0.86