Previous Topic Next Topic

IF

Solved/Closed
Stormdronk - May 25, 2010 at 02:49 AM
 Stormdronk - May 25, 2010 at 06:22 AM
Hello,

If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 25, 2010 at 05:30 AM
inn B1 copy this formula

=IF(A1=80,100,IF(A1=50,90,""))
Answer 2 / 2
Stormdronk
May 25, 2010 at 06:22 AM
Thanks !!!!!!!