Friends,
I am new to this forum....nice to meet you all...
Below is working fine....
but if i add another if like below=IF(D4=5,31,IF(D4=10,56,IF(D4=15,83,IF(D4=20,110,IF(D4=25,135,IF(D4=50,268,IF(D4=100,530,IF(D4=200,1050))))))))
then i am getting an error as "the formula containing an error
where i am making mistake?=IF(D4=5,31,IF(D4=10,56,IF(D4=15,83,IF(D4=20,110,IF(D4=25,135,IF(D4=50,268,IF(D4=100,530,IF(D4=200,1050,IF(D4=200,1560)))))))))
thanks
Bookmarks