Sitemap

Amicuk Programming Answers

Numbers for iPad if statement

2015-10-11   Views:0

Advertisement

I am using numbers for iPad and am trying to do a if statement. Cell A1 has a value of 2 and cell A2 has a value of 3. If I see if(A1<3) I get true if I do if(A1<A2) I get false... Can I not compare two cell values?I may be misunderstanding what you

I am using numbers for iPad and am trying to do a if statement. Cell A1 has a value of 2 and cell A2 has a value of 3. If I see if(A1<3) I get true if I do if(A1<A2) I get false... Can I not compare two cell values?

The replay answer
Advertisement
I may be misunderstanding what you want but here is a start. To make it easier to do the conditional formatting of 30 rows, I suggest putting the color in column C, not column B. If the formatting is in column B you will have to manually edit all 30 of them. In column C, you can copy/paste the format to all the rows.
1. Put the correct answers in column D. You will hide this column after everything is set up.
2. In C1 put the formula =IF(B="","", IF(B=D,D,D&" ")) . This will make C1 blank until an answer is typed into B1. Then it will provide the correct answer (with a single space appended to the end if B has an incorrect answer).
3. Create a conditional format for C1 that is "if text contains a space then fill red".
4. Drag-fill or copy/paste C1 to the rest of the column.
5. Hide column D

Go to See the other 3 answers

How can I insert an image into a cell in Numbers for iPad?

Category:DefaultRelease time:2015-10-11Views:130

Hi, is there any way to insert an image inside a cell using Numbers for iPad? I tried doing it on desktop version and it works, then I shared it through iwork.com and downloaded into my iPad and it's showing fine on the iPad ( although there's no way[More]

How do I add multiple rows in Numbers for iPad?

Category:DefaultRelease time:2015-10-11Views:130

how do I add multiple rows in Numbers for iPad?Hi James, On the iPod I can only insert what is on the clipboard but I can insert however many rows I have there. Is it working differently for you? Benjoon seemed to think that he could not do this in N[More]

HT5824 I've been using numbers for iPad and I accidentally deleted a column. And the auto-save feature saved that and now I can't undo it. Does iCloud storage have backups of saved files from like 10 minutes ago? I have number

Category:DefaultRelease time:2015-10-11Views:130

I've been using numbers for iPad and I accidentally deleted a column. And the auto-save feature saved that and now I can't undo it. Does iCloud storage have backups of saved files from like 10 minutes ago? I have numbers synced to iCloud. I tried to[More]

Adding trendline in Numbers for iPad

Category:DefaultRelease time:2015-10-11Views:130

Can I add trendlines for my charts in Numbers for iPad?Don't type the two letters "nu" but the three "ios" ones. You will get two entries : iMovie for iOS and iWork for iOS (which is ridiculous because this product doesn't exist). Clic[More]

Copy and paste issues - numbers for Ipad

Category:DefaultRelease time:2015-10-11Views:130

Since my Numbers for Ipad last updated I cannot copy and paste an interval of cells to my Gmail App, so I can email. It used to work in the orevious version. What should I do?You are asking about Numbers for iOS in a forum dedicated to Numbers for OS[More]

Setting page size in Numbers on Ipad?

Category:DefaultRelease time:2015-10-11Views:130

Anyone know if you can set page size in Numbers on Ipad?I don't see a setting for page size.  Everything else related to that (sans setting the page size) appears to be found here: Click the wrench Share & Print Print Select portrait/landscape, conte[More]

Limitations of number of populated cells in Numbers for iPad?

Category:DefaultRelease time:2015-10-11Views:130

Does anyone know what the maximum parameters are for Numbers on iPad? I have searched for a knowledge base article on this but cannot find one. I am trying to bring in a excel sheet I converted to Numbers on my MacBook Pro and then brought it into Nu[More]

How do I automatically number rows in Numbers for iPad?

Category:DefaultRelease time:2015-10-11Views:130

How do I automatically number rows in Numbers for iPad?Hi James, On the iPod I can only insert what is on the clipboard but I can insert however many rows I have there. Is it working differently for you? Benjoon seemed to think that he could not do t[More]

How do I delete rows in Numbers for iPad?

Category:DefaultRelease time:2015-10-11Views:130

I am new to numbers for iPad. How do I delete rows in Numbers for iPad? I am able to delete the data in the rows/cells but I can't delete/move up the rows so I can move data in it's place.I havn't got Numbers so I can't check it, but is what is on th[More]

Is there a fill down in Numbers for iPad?

Category:DefaultRelease time:2015-10-11Views:130

Is there a fill down function in Numbers for iPad? Is there a good place to find these types of answers? Thanks!Hi Joe, Is there a fill down function in Numbers for iPad? Yes Is there a good place to find these types of answers? The Help in Numbers a[More]

There is no filter function in numbers for ipad,its very discouraging,as a ipad fan,even nokia lumia providing filter in there low cost mobile

Category:DefaultRelease time:2015-10-11Views:130

there is no filter function in numbers for ipad,its very discouraging,as a ipad fan,even nokia lumia providing filter function in excel in there low cost mobile. APPLE KINDLY PROVIDE THIS FEATURE AS UPDATE SOON,COZ I WORK ON EXCEL N NUMBERS IN MY IPA[More]

Hot
I Phone 4s 16 gb ios 8.0.2 i got my all back but didn't gett gallrry but I did gallrry back up on 13 septemberStart up in Safe Mode. http://support.apple.com/kb/PH14204?viewlocale=en_US Repair Disk. http://support.apple.com/kb/PH5836 Reset PRAM.    h [More]
I'm trying to extract PO header text description. I used call function READ_TEXT, but since this text is wrapped around, how do I display/show this text information at workflow item description. Please advise which forum should I go to see more infor [More]
Hi all, how to import data e.g. word document into cluster cl3. Have some examples for import data in cluster.In cluster 3 are stored audition information of candidates for employee it is transaction PB60. My task is to update this additional informa [More]
What would be the highest computer that apple made which could handel OS 9? I know it is the quick silver G4 (Maybe one with the mirror door), but which one? ThanksHi, Sabrina - What would be the highest computer that apple made which could handel OS [More]
hi , Is there any Std T.code to do Mass price Change of Materials ? regards MikeHi, You also have Tcode MASS for more mass modification. Use object type BUS1001 and generate. Then you have to know the tables where the field you want to modify is. Pic [More]
My 13" Macbook Air, S.N. RM632234U9B, was stolen from my office in Glendale, CA over the Christmas Holidays. I reported it to both company security and the  Police. I had Find My iPhone on it, so I activated the lock code and set the erase function.  [More]
Hi All, I wonder if someone can scratch my head on this. Brand new RDS 2012 R2 deployment. RDS01 with Connection Broker and Session Host Roles installed RDS02 with Web Access and Gateway roles installed one ssl certificate with one domain remote.myco [More]
Have a client with locations in all three US time zones as well as some European countries. Server resides in Oregon (Pacific time). A user in Europe will see the time as 9 hours earlier than it is in France. For example when it is 15:00 in France SA [More]
I posted this in the CS3 forum originally. They told me to post here too. Issue: When logged in as a local user (no admin rights) Word 2007 will crash the whole computer when you type a key. The reason I am posting on Adobe forums is that this only h [More]
Hi guys, I have a problem with slipstreaming the Office 2010 updates. We use a WDS server to do this. During the installation process, WDS needs to slipstream the Office updates. However, this does not happen. When the Office setup is completed we ha [More]