ExcelBanter - If condition

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If condition (https://www.excelbanter.com/excel-programming/332307-if-condition.html)

If condition

Is it possible to code an if-then condition?

For example, if A1=4, then B1 = 40.00.

justaguyfromky

If condition

=if(B1=4,40.00,"")

"" will leave the cell blank if conditions are not true
with more information, a better formula can be written that would work for
different numbers in A1

"L" wrote:

Is it possible to code an if-then condition?

For example, if A1=4, then B1 = 40.00.

All times are GMT +1. The time now is 02:44 PM.