STUMPED on IF OR FUNCTION

[jcastro427]

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

 

[Rick Rothstein]

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?

 

[ukmikeb]

Duplicate thread of :-
http://www.mrexcel.com/forum/excel-questions/979264-stumped-if-function.html

 

[jcastro427]

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

Thanks

 

[tygrrboi]

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