Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
cell A6 is a ratio, and favorable if less than (<) 2.5
cell C6 is the sum of individual ratings Please help if you can fill in the blanks... How do I write this function?? I want to be able to trigger a calculation if two favorable conditions are met. If one condition is met, AND a second condition is also met. How do I write the condition As below is wrong: =if(a6<2.5andc674,(c10+(c10*.10),0)) if both conditions are met, return c10+(c10*.10), if condition not met return 0. How do I write condition -- Sony Luvy |