If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simple formula for newbie!
Hi
Simple question, as just starting with formulas!! But.. I need a formula whereby if cell D1 = 10, then multiply E1*D1. Else multiply F1*D1. Thanks! TC |
#2
|
|||
|
|||
Try...
=IF(D1=10,E1*D1,F1*D1) Hope this helps! In article , "TC" wrote: Hi Simple question, as just starting with formulas!! But.. I need a formula whereby if cell D1 = 10, then multiply E1*D1. Else multiply F1*D1. Thanks! TC |
#3
|
|||
|
|||
TC
You'd almost got it! Try - =IF(D1=10,E1*D1,F1*D1) The IF - THEN - ELSE structure of your question marks you out as a probable basic programmer and with it your possible age. Bill Ridgeway Computer Solutions "TC" wrote in message ... Hi Simple question, as just starting with formulas!! But.. I need a formula whereby if cell D1 = 10, then multiply E1*D1. Else multiply F1*D1. Thanks! TC |
#4
|
|||
|
|||
I got a lot of my begginer help on this site... cool They teach you by making a, Time sheet, Invoice and cheek book from scratch on Windows media Player very cool www.MDOTutorials.com -- Route2391 ------------------------------------------------------------------------ Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774 View this thread: http://www.excelforum.com/showthread...hreadid=396823 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
help with simple formula | bj | Worksheet Functions | 1 | June 17th, 2005 03:30 PM |
need help with a simple time formula | wize | Worksheet Functions | 2 | April 23rd, 2005 01:32 AM |
Simple Date Formula | FreddieTheFrog | General Discussion | 6 | June 24th, 2004 10:47 PM |
simple formula | Ash T. | General Discussion | 8 | June 12th, 2004 03:52 PM |
Simple formula nested in ISERR | P. Balmanno | Worksheet Functions | 1 | March 31st, 2004 02:09 AM |