Formula Issue

[markb1009]

I need a formula which as an example, when A1 is 6, then it multplies A2 by 8.0186 and puts this value in cell A3, however if A1 is 8 then it multiples A2 by 14.2554 and places the value in A3


Thanks Everyone

 

[Joe4]

Welcome to the Board!

Formula to put in A3:

=IF(A1=6,A2*8.0186,IF(A1=8,A2*14.2554,"No match"))

It will return "No match" if A1 is not 6 or 8.
You can change that part to return whatever you want, in that case.

 

[jproffer]

Something like this:

Excel 2013/2016

	A
1	8
2	10
3	142.554

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula A3 =IF(A1=6,A2*8.0136,IF(A1=8,A2*14.2554,"Neither 6 nor 8")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Oops, I put 8.0136 instead of 8.0186. Sorry about that.

 

[markb1009]

Thanks Joe, this works, how can I leave the cell blank if there is no 6 or 8 chosen in the others?

 

[Joe4]

how can I leave the cell blank if there is no 6 or 8 chosen in the others?

Just remove all text between the double-quotes, i.e.

=IF(A1=6,A2*8.0186,IF(A1=8,A2*14.2554,""))

 

[markb1009]

Thanks for help

 

[Joe4]

You are welcome!

 

[markb1009]

Thank you for all the help, everything works perfect.