ExcelBanter - Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/256808-excel-2003-a.html)

Cat

Excel 2003

I am trying to create a formula:

IF A2 equals Y then I want a7 to multiply A3 by 2.5%

I can't get this to work for me!!

TomPl

Excel 2003

Put this formula in A7:

=IF(A2="Y",A3*0.025,"Nothing")

Tom

Cat

Excel 2003

Thank you - Worked beautiful!!
Cat

"tompl" wrote:

Put this formula in A7:

=IF(A2="Y",A3*0.025,"Nothing")

Tom

All times are GMT +1. The time now is 05:35 PM.