Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I have a cell (cell1) with this formula =IF((K11)="","",SUM((K11)/(AB12))*1000) Then I have another cell (cell2) which derives its value from cell1 (and another cell) =IF((K14)0, IF((K11)<"",SUM(K14+K11),""),"") If the value in cell1 = 0 then I want to modify the formula for cell2 (pseudocode here) to look something like this: =IF((K14)0, IF((K11)<"" OR ((K11) 0),SUM (K14+K11),""),"") Obviously, this formula doesn't work. Is there a way to write a formula with an OR clause along with the IF statement? Thanks, Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |