Help with IF function please

Copper Contributor

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

1 Reply

@hnqn13 

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