| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using more than one IF function
=IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"")
After several rewrites, this function works and does not return an error when the cells are blank, but now I can't format the cells that contain this function. Strange. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using more than one IF function
EnigmaKat;197108 Wrote: =IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"") After several rewrites, this function works and does not return an error when the cells are blank, but now I can't format the cells that contain this function. Strange. What do you mean by formatting? Manual, conditional ? What goes wrong? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54300 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using more than one IF function
Thank you for responding. The formatting that is in the cell when the
function is written gets overridden and I can't change it manually. When I open the formatting dialogue box, the selections are still in place but the cell does not reflect the style. "Pecoflyer" wrote: EnigmaKat;197108 Wrote: =IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"") After several rewrites, this function works and does not return an error when the cells are blank, but now I can't format the cells that contain this function. Strange. What do you mean by formatting? Manual, conditional ? What goes wrong? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54300 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using more than one IF function
Please explain what formatting you are trying to do and how. Are you saying
that you can't bold the cell? What version of Excel are you using? Are you applying formats to a table range? Are you using conditional formatting? -- If this helps, please click the Yes button Cheers, Shane Devenshire "EnigmaKat" wrote: Thank you for responding. The formatting that is in the cell when the function is written gets overridden and I can't change it manually. When I open the formatting dialogue box, the selections are still in place but the cell does not reflect the style. "Pecoflyer" wrote: EnigmaKat;197108 Wrote: =IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"") After several rewrites, this function works and does not return an error when the cells are blank, but now I can't format the cells that contain this function. Strange. What do you mean by formatting? Manual, conditional ? What goes wrong? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54300 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using more than one IF function
Thank you for responding. The error turned out to be the double quotes that
I had input for a "false" response. The value should be zero. Thanks, again. "Shane Devenshire" wrote: Please explain what formatting you are trying to do and how. Are you saying that you can't bold the cell? What version of Excel are you using? Are you applying formats to a table range? Are you using conditional formatting? -- If this helps, please click the Yes button Cheers, Shane Devenshire "EnigmaKat" wrote: Thank you for responding. The formatting that is in the cell when the function is written gets overridden and I can't change it manually. When I open the formatting dialogue box, the selections are still in place but the cell does not reflect the style. "Pecoflyer" wrote: EnigmaKat;197108 Wrote: =IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"") After several rewrites, this function works and does not return an error when the cells are blank, but now I can't format the cells that contain this function. Strange. What do you mean by formatting? Manual, conditional ? What goes wrong? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54300 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
