# Multiply IF

#### Lawbut

##### New Member
Beginner!

Trying to multiply FG and I6, IF C6>=1

=F6*I6(IF(C6>=1)

Help!

Thanks

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

#### Vidar

##### Well-known Member
Try

=IF(C6>=1,F6*I6,"")

#### Snakehips

##### Well-known Member
Lawbut,

Welcome to MrExcel.

Assuming that the outcome if C6 is < 1 = 0 then...

=IF(C6>=1,F6*I6,0)

Hope that helps.

#### Lawbut

##### New Member
Thank you - Worked perfectly!

#### Lawbut

##### New Member
Thanks Snakehips,

Replies
4
Views
346
Replies
3
Views
155
Replies
5
Views
853
Replies
3
Views
124
Replies
4
Views
105

1,191,685
Messages
5,988,002
Members
440,125
Latest member
vincentchu2369

### 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