# STUMPED on IF OR FUNCTION

#### jcastro427

##### New Member
SORRY...My mistake;
I am stumped, I want to have a function that will multiply either the entry in A1 or in B1 by the entry in C1.
I used to know how to write this and it appears I know longer do.

I have tried: =IF(OR(A1>="1",B1>="1"),*C1,"")

In words; if A1 is greater to or equal to 1 OR if B1 is greater to or equal to 1 then
multiply that cell byC1

Thanks for any help...

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### Rick Rothstein

##### MrExcel MVP
In words; if A1 is greater to or equal to 1 OR if B1 is greater to or equal to 1 then
multiply that cell byC1
Is it possible for A1 and B1 to both be greater than 1 at the same time?

#### jcastro427

##### New Member
Well they could be but they shouldn't be...I did get the solution earlier though from another reply.

Thanks

#### tygrrboi

##### Well-known Member
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}</style>
=IF(MAX(A1:B1,0)=0,"",MAX(A1:B1,0)*C1)

Last edited:

Replies
1
Views
73
Replies
2
Views
143
Replies
6
Views
416
Replies
0
Views
275
Replies
6
Views
127

1,190,558
Messages
5,981,688
Members
439,730
Latest member
gjvv

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