| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to calculate results in one cell, based on data of another
Hello,
Here's my problem: If A1 is less than or equal to 49.95, I need B1 to show a result of 12.48. If A1 is greater than 49.95, I need B1 to multiply the A1 number by 50%. Here's the formula I've been trying to use, but it isn't working the way I need it to: =IF(AND(A1<=49.95,B1=12.48,IF(A149.95,B1*0.5,0))) I really don't know what I'm doing wrong. Any suggestions would be great. Thanks, ADC76 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value a cell based on vlookup results | Excel Worksheet Functions | |||
| Report row results based on the last data entry in a column | Excel Discussion (Misc queries) | |||
| Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| =If() results based on cell color? | Excel Worksheet Functions | |||
Threaded Mode
