Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there Paul,
I think that should be "=IF(C1<0, A1, 'value you want it b1')". Commas, not semi-colons. (Paul I think you typed too fast <g) No, I copied what the OP had used thus: "...Well I tried to insert the following function in B1: =If(c1<0;a1) but it returns..." Aha!!! I see. Perhaps I should have checked against the initial post =). See ya Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Creation via Add-in problem | Excel Programming | |||
Problem with chart creation. | Charts and Charting in Excel | |||
Problem with chart creation | Excel Discussion (Misc queries) | |||
Ultimate circular problem for chart creation | Excel Discussion (Misc queries) | |||
Automatic Number Creation Problem? | Excel Worksheet Functions |