Thread
:
if 200 and <300 formula
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Piscator
external usenet poster
Posts: 10
if 200 and <300 formula
One way is with two IF statements. logically reads:
If (A1200 then If A1<300 then A1, else 0), else 0)
=IF(A1200,IF(A1<300,A1,0),0)
Reply With Quote
Piscator
View Public Profile
Find all posts by Piscator