Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble with IF
I am trying to get a cell to render a positive value or a negative value of a
certain number if another cell has one of two letters. i.e.: if the value of cell J12 = .28 and the first letter of cell C12 is B, then the value of cell K12 = (0.28). if the value of cell J12 = .28 and the first letter of cell C12 is S, then the value of cell K12 = 0.28. I am stuck. Can someone shed some light? eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble formatting date | Excel Worksheet Functions | |||
Still having trouble | Excel Discussion (Misc queries) | |||
Trouble Forecasting | Excel Discussion (Misc queries) | |||
UGH! Trouble downloading, and opening anything | Excel Discussion (Misc queries) | |||
trouble shooting section | Excel Discussion (Misc queries) |