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
Greetings!  My Late 2012 MacMini  Running 10.10.1  had a crash this morning - leaving no kernel panic log... I noticed an odd group of messages in the system log though - and in fact right now there is a stream of about 4000 of them: (I will post TWO [More]
Hi, I have created a ZRPO for Return purchase orders. However when we create a Return PO and save , the system always calls the PO form. I checked under messages, the ZRPO is also assigned but the NEU is assigned first for all Return PO's. The config [More]
I just had a very weird issue, I purchased a 22" samsung DVI display I got pretty cheap off of Ebay, I originally was using a 20" Cinema Display and love it, but I want like most of us I guess ,more real estate. The Samsung has no USB ports as t [More]
Where is photoshop elements 11 catalog files stored in windows 7 for carbonite to back up?  Also any other files besides the pictures that I should back up?[email protected] wrote: Where is photoshop elements 11 catalog files stored in windows 7 for [More]
Hi all! I'm reading an xls and i need to fill me oracle objects with java code: OBJECT_NAME OBJECT_TYPE LETTURA_OBJ TYPE LETTURA_OBJ TYPE BODY In the past weeks i've been using both java code into oracle and oracle objects, but new i need to write th [More]
Hi, I just upgraded my CP 5 to CP 5.5 and discovered that all my project templates are NOK anymore This is what I see: All Placeholders no matter which one have an angle of -1 in CP 5.5. I opened the templates in CP 5 and they are still OK. Reopen in [More]
I am trying to open some slides my professor posted on Desire 2 Learn. It is a .pptx file. Everytime I try to open it I get an error message that says, "Powerpoint cannot access +I (drive) beacuse the file has been moved or deleted" I have unins [More]
Hey, just checking in. What's the status of the web version of the content viewer? As I recall, a target date of May was mentioned.Thanks for the addtional info. Two followups, if I may. (I'm planning for a future app release right now, which this co [More]
I recently downloaded the free trial with which I am very impressed. I have started cataloguing past photos and have ordered the full version (shh from Amazon - sorry!). Whilst waiting for it to arrive I want to keep working on my pictures - I assume [More]
I have a PowerBook G4, came with Airport card. We travel in an RV and over the past year have stayed at numerous campgrounds with WIFI, and my laptop has connected fine, as long as the signal strength is good enough. So I know it works, or at least h [More]