conditional formula in Excel
Assuming your number is in A1, then try this out in B1:
=IF(A1<=0.35,"Level I",IF(A1<=0.7,"Level II","Level III")
Hope this helps.
Pete
On Jul 6, 9:36 pm, mreedtigers
wrote:
Hey,
Please help. I'm trying to write a formula for the following:
If A <= 0.35, then "Level I" or if A 0.35 and <= 0.70, then "Level II" or
if A 0.70, then "Level III".
Can somebody help me with this?
|