Forum Home
Press F1
Thread ID: 93031	2008-09-01 17:15:00	Excel value throws error	Nironto (14134)	Press F1

Post ID	Timestamp	Content	User
701858	2008-09-01 17:15:00	Hi, I'm trying to compute a excel formula that if value =0, it will appear as (0) if value = 1-49 ( low) if value = 50 -100 (high) =If(B3=0, 0,IF B3<=49, "LOW", "HIGH")) It throws error, too many arguments. what's wrong?	Nironto (14134)
701859	2008-09-01 17:20:00	H guys, I figured it out! here's the formula. Thanks! =IF(B3<=0,0,IF(B3<=49,"LOW","HIGH"))	Nironto (14134)
1