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
Hi , I am working on  Project resource Create conversion , i did the mapping it work fine but while loading i got the error , in the log message RETURN_STATUS= 'E' X_MSG_DATA = 'JTF' I am not able to understand error data that is 'JTF' . Please if so [More]
I have tried everything to disable the AutomaticDeviceSync.  I have created the HKEY_LOCAL_MACHINE\Software\Apple Computer, Inc.\iTunes\Parental Controls\Default\AdminFlags HKEY_CURRENT_USER\Software\Apple Computer, Inc.\iTunes\Parental Controls\User [More]
I am installing an ipad connected to a hd tv in a new business and need it to mirror onto the tv. When I have done this in the past i have experience lag/buffering and sometimes loss of signal. What is the best way to connect an iPad to a hd TV? (To [More]
I'm trying to acess my iDisc and it's not working.  Message pops up that says "iDisc not mounted", what does this mean?  I can no longer download music or movies from itunes also, because it says startup disc is full.  I've tried to delete items [More]
In the latest release of Firefox, information about how to prevent plug-ins from loading automatically was in the release notes. I activated this in about:config. (Click-to-play). After that, I cannot open pdf files! When I click on a link all I get [More]
Back in 2005 (Win PS CS) I wrote a javascript script which allows me to batch add captions, headlines, author, etc to JPEG image files.  When CS3 came along I found I needed to turn off ACRs JPEG processing before I ran the script and on again after [More]
Here is the snippet of code I am using on a master/detail page (Using spry). The goal is to delete the employee, and upon completion have the master list use a blind up effect to get rid of that row in the list. function deleteEmployee() { var test = [More]
I have been looking online and in my Speaking Photoshop CS6 instruction book and cannot find where to straighten only part of an image.  Some of the image is straight but he middle section needs adjustment, straightening.  I can only find how to stra [More]
Using Dreamweaver CS3, I have created a slide show using Flash CS3. I want to have a flash button overlap just part of the flash side show. What happens is the button part that overlaps the flash slide show, is behind the slide show. And when I move [More]
i just installed puma on my ibook g3 because it runs to slow with tiger or panther. i downloadded the 10.1.1, 10.1.2, 10.1.3 combo, and 10.1.5 updates, my harddrive is grayed out on all of them. my other problem is that my external 250gb harddrive wi [More]