I am new to excel and working on a question in excel that says(In the range
B18:H22 use the =IF function to print the message, Insignificant, for any percent less than 3%. Otherwise, print the percent. How do I put that answer in the cell?
I am new to excel and working on a question in excel that says(In the range
B18:H22 use the =IF function to print the message, Insignificant, for any percent less than 3%. Otherwise, print the percent. How do I put that answer in the cell?
=if(a1 < 3%, "Insignificant", a1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks