| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
creating formula using if function
I confused about creating formula using if function for the condition below.
Labor costs for items with material costs of at least $100 but less than $500 are estimated at 50% of material costs. I tried everything but did not work please help (for example A1 contains a material cost) =if(A1=100<500,A1*0.50) isn't that correct? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula within IF function | Excel Discussion (Misc queries) | |||
| Need Help: 'sheets' function with a variable in a formula | Excel Worksheet Functions | |||
| undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| function of "+" in the formula "=+(B19/50)*B10 | Excel Discussion (Misc queries) | |||
Threaded Mode
