ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Specific formulae required (https://www.excelbanter.com/setting-up-configuration-excel/453892-specific-formulae-required.html)

Oldschool

Specific formulae required
 
Hi,
I need a specific formula.

R13 to = D13 if I13 has 1 in it.

Can any one help please.

Oldschool

Specific formula required.
 
=if(I13=1,D13,"0").


All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com