Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Help - Simple Formula ! | Excel Discussion (Misc queries) | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |