bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
hello
=IF(AND(S11>0,V11>0),"ISE Total",IF(AND($Q$11=0,$R$11=0),"ISE Purge Total",IF(AND($T$11=0,$U$11=0),"ISE Auto Total","No Data"))"No Data")
basically, its saying its too many arguments bc of the "No Data" portion.
what im trying to say in...
if S & V are > 0, then "ISE Total"...
other if statements in between....
if S & V contain no data "No data"
can someone point out the obv here. pls and thx u!
=IF(AND(S11>0,V11>0),"ISE Total",IF(AND($Q$11=0,$R$11=0),"ISE Purge Total",IF(AND($T$11=0,$U$11=0),"ISE Auto Total","No Data"))"No Data")
basically, its saying its too many arguments bc of the "No Data" portion.
what im trying to say in...
if S & V are > 0, then "ISE Total"...
other if statements in between....
if S & V contain no data "No data"
can someone point out the obv here. pls and thx u!