MS Excel Help

This query is : Resolved

Alok Kumar (Querist)
Follow

15 April 2009 Sirs,

I have done some validation in Excel Sheet, i.e. i have used IF Formula but the number of entries is restricted to number 8 (eight) only. If i am putting any formula using 'IF' after 8th item the error is errupting that Formula is wrong.

So, my Q? is that is it possible to increase the number of entries using IF Formula?

Sachidanand Singh

Sachidanand Singh (Expert)
Follow

16 April 2009 Use two IF() formulae in the same cell with a plus (+) in between. Example:

If(condition1 meets, value1,if(condition2 meets,value2, if(....value7,0)))))))+ If(condition8 meets, value 8, if(condition9 meets, value9, if(... so on.

It should do.