Previous Topic Next Topic

MS xl formulah

Closed
Rezwan.dhaka Posts 1 Registration date Saturday January 25, 2014 Status Member Last seen January 25, 2014 - Jan 25, 2014 at 11:14 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 28, 2014 at 12:15 AM
how to show conditional result in another cell in ms xl?
for example, if A2 is >5% then the result would be 20 in B2

1 reply

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 28, 2014 at 12:15 AM
In B2 type thils formula

=IF(A2>5%,20,"")
0