Excel - automatic cell fill

Microsoft Excel 2007
March 6, 2010 at 04:13:56
Specs: Windows XP
hi, i'm trying to get a cell in excel (d2) to automatically fill, based on a value in another cell (a3). e.g: if a3 has a value of between 2-5 den d2 will display 100, or if a3 has a value of between 6-9 den d2 will display 105. if someone could please help me, thanx!

See More: Excel - automatic cell fill

Report •


#1
March 6, 2010 at 04:46:23
Hi,

This formula in cell D2 returns the values you gave in your example:

=IF(A3<2,"",IF(A3<6,100,IF(A3<10,105,"")))

The formula first tests if Cell A3 is less than 2 and if it is less than 2 it shows nothing "". It then tests to see if A3 is less than 6 and if it is less than 6 it shows 100, if it is not less than 6 it tests A3 again to see if it is less than 10 and if it is less than 10 it shows 105, but if it is not less than 10 it shows nothing.

Using the IF() function multiple times one inside another is known as a nested IF.

Regards


Report •

#2
March 7, 2010 at 04:54:46
Thank you!

Report •
Related Solutions


Ask Question