Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

MS xl formulah [Closed]

Report
Posts
1
Registration date
Saturday January 25, 2014
Status
Member
Last seen
January 25, 2014
 -
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 -
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
See more

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 791
In B2 type thils formula

=IF(A2>5%,20,"")
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!