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

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]142.554[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A3[/TH]
[TD="align: left"]=IF(A1=6,A2*8.0136,IF(A1=8,A2*14.2554,"Neither 6 nor 8"))

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


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.