formatting
THANK YOU :-)
"muddan madhu" wrote:
try this
=IF(AND(A2=0,A2<=100),A2*2,IF(AND(A2100,A2<=200) ,A2*3,""))
On Nov 17, 3:43 pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3
Can anyone help please
|