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 All, This is our first upgrade experience and we are a bit confused with the steps we should follow to upgrade PT. We are on 8.47 and planning to upgrade to 8.50. After reading the installation notes and other material, there is a bit of confusion [More]
<p>When using Data Integrator (DI) to process a mix of multi-byte and single-byte data, it is recommended that you use UTF-8 for the job server codepage. You can, however, use different codepages for the individual datastores.</p><p>Imag [More]
I just recently built a new computer, using the same hard drive i had but reformatting it with all the new components. I backed up all my files on the old version of the hdd, and i thought of using my iPod nano as a backup for all my music files, con [More]
Hello I'm slogging my way through teaching myself how to use my Premire Pro software for HD editing after coming from Final Cut Pro in standard definition.  I'm on a good Mac work station and have done pretty well so far but am now back at the start [More]
I am zooming in on my homework in mastering physics. I am using a large screen and sitting far away. It uses a lot of images containing the text I need to read, but when the images are upscaled, they become very blurry and hard to read. A simple shar [More]
When I try to print on 4x6 or 5x7 paper the printer is saying that it is out of paper. It will print on 81/2 x 11. not sure what is going on.Hi - Try following the steps in this document.  It should help resolve the issue. Hope that helps. Say Thanks [More]
Below a few low-cost but potentially useful tools and features that you could consider for the next big update in Q2 (feel free to add any other ideas): (1) Menu Button vs. Recent Apps Button Mostly in the EMEA we are used to have a dedicated "Recent [More]
Hi, can anyone help me! I have four movie clips with instance names of "purple_ob", "green_ob", "orange_ob" and "blue_ob" and four buttons "purple_but", "green_but", "orange_but" and &q [More]
After I look at the source codes of the RestoreViewPhase.java and ViewHandler,I find that "createView" only to get an instance of the UIViewRoot class,and not add any children at all.So I want to know how JSF can get the component Tree from the [More]
Old I-tunes accepted both my i-pods - now it only accepts one and tells me the second cannot be synched as a duplicate name has been used. There is no explanation as to what I must do to put this right....can anyone help with this? Thanks.   If you a [More]