# How to use an IF statement to show a number or a blank cell

#### Joshua88

##### New Member
hello all, so i have a formula in cell M12 that shows the sum of =E12-L1*2+1.625 , my problem is when E12 is blank M12 shows a negative number, i would like if E12 is blank for M12 to show nothing and if i input a number into E12 for it to show the sum of the equation IN M12, I think this can be done with a IF THEN STATMENT?

thanks for the help

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### mehidy1437

##### Active Member
Try below,

=if(e12="","",E12-L1*2+1.625)

#### Joshua88

##### New Member
Try below,

=if(e12="","",E12-L1*2+1.625)
[/QU
awesome it worked thank you

#### mehidy1437

##### Active Member
you are welcome, thanks for the feedback.

Replies
9
Views
165
Replies
3
Views
61
Replies
2
Views
90
Replies
5
Views
46
Replies
1
Views
84

1,127,531
Messages
5,625,368
Members
416,096
Latest member
forevans

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back