Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel formula- If and 1

Status
Not open for further replies.
jlr123

jlr123

Technical User
Joined
Feb 24, 2014
Messages
117
Location
US
I need a formula that represents the folowing:
If b2=c2 and R2>0 then R2 else 0

Could use the help today if possible.

Thanks very much!
 
Sort by date Sort by votes
How about: [tt]=IF(AND(B2=C2, R2>0), R2, 0)[/tt]

More about AND function here

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BxWill
  • Question Question
MS EXCEL 2016 LINE CHART NOT DROP TO ZERO - USING NESTED IF AND COUNTIF
Replies
1
Views
150
combo
combo
arvarr
  • Locked
  • Question Question
Excel Formula Help
Replies
7
Views
1K
SkipVought
S
PSchubert
  • Locked
  • Question Question
Excel: Formula only works with certain numerical values
Replies
12
Views
2K
dhookom
dhookom
Andrzejek
  • Locked
  • Question Question
Formula with & and a single quote
Replies
4
Views
1K
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
1K
bs6600
bs6600

Part and Inventory Search

Sponsor

Back
Top