Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Urgent help needed: IF function
Dear all,
I need help on the following problem urgently: In my worsheet: Cell(K,38) = 2 Cell(C,107) = 0.8 Cell(C,108) = 280000 In Cell(K,108), I have a formula: K38*$C108*$C$107 The the value of Cell(K,108) is 448000 Now I have the change the formula on Cell(K,108). It should reference to it's cell to the left, i.e. Cell (J,108). If Cell(J,108)=0, then I have to multiply the original formula by 0.5, i.e. (K38*$C108*$C$107) * 0.5, otherwise, it keeps the original formula K38*$C108*$C$107. But the cells doesn't come out with the result, it displays the formula instead: "=IF (J108=0,"K38*$C108*$C$107","0.5*(K38*$C108*$C$107) ")" Why does this happen? Can anyone help? Thanks in advance!! Terence |
#2
|
|||
|
|||
Try Pressing Ctrl+` (the button usually directly below Esc)--you may be
displaying Formulas instead of Formula results. That should switch it back to showing formula results. But, if I read your post correctly, it sounds like you are really looking for this: =IF(J108=0,(K38*$C108*$C$107)*0.5,K38*$C108*$C$107 ) If all those quotation marks are really in your formula, that is probably the problem. Anything displayed within " " displays literally in the cell. tj "Terence" wrote: Dear all, I need help on the following problem urgently: In my worsheet: Cell(K,38) = 2 Cell(C,107) = 0.8 Cell(C,108) = 280000 In Cell(K,108), I have a formula: K38*$C108*$C$107 The the value of Cell(K,108) is 448000 Now I have the change the formula on Cell(K,108). It should reference to it's cell to the left, i.e. Cell (J,108). If Cell(J,108)=0, then I have to multiply the original formula by 0.5, i.e. (K38*$C108*$C$107) * 0.5, otherwise, it keeps the original formula K38*$C108*$C$107. But the cells doesn't come out with the result, it displays the formula instead: "=IF (J108=0,"K38*$C108*$C$107","0.5*(K38*$C108*$C$107) ")" Why does this happen? Can anyone help? Thanks in advance!! Terence |
#3
|
|||
|
|||
Be sure the cell that is misbehaving is not formatted as text. If it is,
Edit/Clear/Formats. You may also need to re-enter the formula. On Mon, 15 Nov 2004 18:04:17 -0800, "Terence" wrote: Dear all, I need help on the following problem urgently: In my worsheet: Cell(K,38) = 2 Cell(C,107) = 0.8 Cell(C,108) = 280000 In Cell(K,108), I have a formula: K38*$C108*$C$107 The the value of Cell(K,108) is 448000 Now I have the change the formula on Cell(K,108). It should reference to it's cell to the left, i.e. Cell (J,108). If Cell(J,108)=0, then I have to multiply the original formula by 0.5, i.e. (K38*$C108*$C$107) * 0.5, otherwise, it keeps the original formula K38*$C108*$C$107. But the cells doesn't come out with the result, it displays the formula instead: "=IF (J108=0,"K38*$C108*$C$107","0.5*(K38*$C108*$C$107 ) ")" Why does this happen? Can anyone help? Thanks in advance!! Terence |
#4
|
|||
|
|||
But the cells doesn't come out with the result, it
displays the formula instead: "=IF (J108=0,"K38*$C108*$C$107","0.5*(K38*$C108*$C$107) ")" One guess is that K108 is formatted as Text Try this: Select K108 click Format Cells General OK Then click inside the formula bar and press ENTER (to re-enter the formula) K108 should compute properly now But .. if I've read your intent correctly, perhaps you might also want to change the formula in K108 to: =IF(J108=0,K38*$C108*$C$107*0.5,K38*$C108*$C$107) (with the value_if_TRUE/FALSE switched around) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Terence" wrote in message ... Dear all, I need help on the following problem urgently: In my worsheet: Cell(K,38) = 2 Cell(C,107) = 0.8 Cell(C,108) = 280000 In Cell(K,108), I have a formula: K38*$C108*$C$107 The the value of Cell(K,108) is 448000 Now I have the change the formula on Cell(K,108). It should reference to it's cell to the left, i.e. Cell (J,108). If Cell(J,108)=0, then I have to multiply the original formula by 0.5, i.e. (K38*$C108*$C$107) * 0.5, otherwise, it keeps the original formula K38*$C108*$C$107. But the cells doesn't come out with the result, it displays the formula instead: "=IF (J108=0,"K38*$C108*$C$107","0.5*(K38*$C108*$C$107) ")" Why does this happen? Can anyone help? Thanks in advance!! Terence |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |