Posted to microsoft.public.excel.worksheet.functions
|
|
if 200 and <300 formula
Or even
=A1*(A1200)*(A1<300)
--
Regards
Roger Govier
"Rick Rothstein (MVP - VB)" wrote in
message ...
how do i do a if A1 200 and <300 return A1 otherwise
return 0. i can't get the logic to work
Everyone has given you the IF function method, so let me be
different.<g
=A1*AND(A1200,A1<300)
Rick
|