Thread
:
IF Statement - AND, OR
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
IF Statement - AND, OR
try something like (untested)
=IF(or(AND(D5$100,000,E510%),AND(D5<-$100,000,E5<-10%)),"yes","no")
--
Don Guillett
SalesAid Software
"James Hamilton" wrote in message
...
Hi,
I have a formula as follows:
=IF((AND(D5$100,000,E510%)),"yes","no")
I want to add another condition as follows:
=IF((AND(D5<-$100,000,E5<-10%)),"yes","no")
...and I can't get it to work.
Any assistance would be appreciated.
James
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett