Numbers If Statement Help - MacRumors Forums
Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 9, 2009, 12:07 PM   #1
Devan
macrumors newbie
 
Join Date: Jan 2009
Numbers If Statement Help

Ive created a way i can manage some projects on numbers for a few paid clients.

Just wondering how would i do this?

If Project Status = Active
Echo Project Name + Project Description + Due Date + Client Name

any ideas?

Some clients have multiple projects in their spreadsheet.

any ideas?
Devan is offline   0 Reply With Quote
Old Jan 9, 2009, 02:11 PM   #2
reclusivemonkey
macrumors 6502
 
Join Date: Jun 2008
Location: Sowerby Bridge, West Yorkshire, UK
For a single line, you can use something like;

Code:
=IF(A2="Active",CONCATENATE(B2,"-",C2,"-",D2)
reclusivemonkey is offline   0 Reply With Quote
Old Nov 30, 2012, 03:26 PM   #3
mikeyb01603
macrumors newbie
 
Join Date: Nov 2012
If Statement Help

Hi People,

I am trying to find out if it is possible to change the color of a cell using the If Statement.

I have a function set-up to monitor my medication stock so that when a particular medication's stock falls below a certain number the cell text changes to "Re-Order"; however I would really like to have the cell color change too.

Any ideas ?

Regards,

Mike
mikeyb01603 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
If-else statement not evaluating alexatwater iPhone/iPad Programming 2 Mar 13, 2014 01:38 PM
Numbers vs Excel when mixing text & numbers TheBlackLabEdge Mac Applications and Mac App Store 5 Mar 6, 2014 08:29 PM
applescript if statement wild4life2013 Mac Programming 2 Aug 5, 2013 11:16 PM
Plotting very small numbers in Numbers tnsmart Mac Applications and Mac App Store 2 Aug 26, 2012 05:16 PM

Forum Jump

All times are GMT -5. The time now is 11:00 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC