If Functions(Advanced) in Excel Excel
=IF
(AND(B3>50,C3>50),B3+C3,B3*C3)
The IF statement
says if the value of the two cells B3 and C3 are more prominent than
50 at that point include these cells else duplicate these cells. See
the picture given below:
=IF(B4>AVERAGE(C4:C9),"cell
B4>average","")
The IF statement
says if the value in cell B4 is more than the normal of the cells
from C4 to C9 at that point show "cell B4>average" else
leave the cell clear.
Your website is very good and nice information was provided in your site, thanks for sharing.
ReplyDeleteAdvanced Excel Training in Hyderabad
Nice Blog post. Thanks for sharing great information. keep posting..
ReplyDeleteSAP S/4 HANA training online
Good article and very genuine.Thanks for sharing a valuable information.please visit our website.
ReplyDeleteAdvanced Excel Training in Hyderabad
Thank you for posting this excellent information..it is very useful to me..!
ReplyDeleteClick here:
Excel Training
Nice and Good article.Your information help others to learn Advanced Excel course.Thank you very much.Keep writing.
ReplyDelete