ExcelBanter - How can I set up the conditions

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How can I set up the conditions (https://www.excelbanter.com/new-users-excel/178609-how-can-i-set-up-conditions.html)

Sean

How can I set up the conditions

Hi,
I'm trying to set up condition of to var. exp( if var1=empty then var2=0)

AKphidelt

How can I set up the conditions

try

=If(var1="",var2=0,whateveryouwanthere)

"Sean" wrote:

Hi,
I'm trying to set up condition of to var. exp( if var1=empty then var2=0)

All times are GMT +1. The time now is 03:47 AM.